Final Project

Football Stats Made Easy

In this project I hope to be able to simplify the statistics of football players to a point where those who do not follow the sport can statistically say who the best players are and maybe some of the reasons they perform so well.

library(tidyverse)
library(easystats)
library(modelr)
library(ggplot2)
library(janitor)
library(dplyr)
library(knitr)
library(magrittr)
library(kableExtra)
library(h2o)


df <- read_csv("./england-premier-league-players-2018-to-2019-stats.csv") %>% clean_names()

dfMatches <- read_csv("./england-premier-league-matches-2018-to-2019-stats.csv") %>% clean_names()

dfTeams <- read_csv("./england-premier-league-teams-2018-to-2019-stats.csv") %>% clean_names()

2018/2019 Premier League Teams

These are the teams that participated in the Premier League in the 2018 to 2019 season. The Premier league is the best league based in the united kingdom. To make it to the premier league a team must be top 3 in the league in which you are then promoted to the next league and the 3 lowest teams in the league above then get demoted.

AFC Bournemouth

knitr::include_graphics(path = "AFC.png")

AFC <- filter(df, current_club == "AFC Bournemouth") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(AFC, format = "html" ,caption = "Stats for Football Team AFC Bournemouth",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team AFC Bournemouth
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Adam Smith	31	1991-04-29	Defender	2073	England	25	1	1	0	0	9	30	6	1	0.04
Andrew Surman	36	1986-08-20	Midfielder	1438	England	18	0	0	0	0	5	35	2	0	0.00
Artur Boruc	42	1980-02-20	Goalkeeper	1080	Poland	12	0	0	0	0	4	17	2	0	0.00
Asmir Begović	35	1987-06-20	Goalkeeper	2160	Bosnia and Herzegovina	24	0	0	0	0	5	44	0	0	0.00
Callum Wilson	30	1992-02-27	Forward	2535	England	30	14	9	1	1	9	44	3	0	0.50
Charlie Daniels	36	1986-09-07	Defender	1583	England	21	1	0	0	0	6	32	4	0	0.06
Chris Mepham	24	1997-11-05	Defender	849	Wales	13	0	1	0	0	3	16	1	0	0.00
Dan Gosling	32	1990-02-01	Midfielder	1737	England	25	2	1	0	0	7	31	8	0	0.10
David Brooks	25	1997-07-08	Forward	2278	England	30	7	5	0	0	9	39	3	0	0.28
Diego Rico	29	1993-02-23	Defender	607	Spain	12	0	0	0	0	0	18	1	0	0.00
Dominic Solanke	25	1997-09-14	Forward	341	England	10	0	1	0	0	2	4	0	0	0.00
Emerson Hyndman	26	1996-04-09	Midfielder	37	USA	1	0	0	0	0	0	2	0	0	0.00
Jack Simpson	25	1996-12-18	Defender	403	England	6	0	0	0	0	2	9	0	0	0.00
Jefferson Lerma	28	1994-10-25	Midfielder	2511	Colombia	30	2	0	0	0	8	45	12	0	0.07
Jermain Defoe	40	1982-10-07	Forward	21	England	4	0	0	0	0	2	2	0	0	0.00
Jordon Ibe	26	1995-12-08	Midfielder	795	England	19	1	1	0	0	4	21	1	0	0.11
Joshua King	30	1992-01-15	Forward	2974	Norway	35	12	3	5	1	9	54	3	0	0.36
Junior Stanislas	32	1989-11-26	Midfielder	1027	England	23	2	3	1	0	7	24	1	0	0.18
Kyle Taylor	23	1999-08-28	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Lewis Cook	25	1997-02-03	Midfielder	721	England	13	0	0	0	0	3	10	2	0	0.00
Lys Mousset	26	1996-02-08	Forward	345	France	24	1	0	0	0	5	13	1	0	0.26
Marc Pugh	35	1987-04-02	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Mark Travers	23	1999-05-18	Goalkeeper	180	Republic of Ireland	2	0	0	0	0	1	5	0	0	0.00
Matt Butcher	25	1997-05-14	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Nathan Aké	27	1995-02-18	Defender	3412	Netherlands	38	4	0	0	0	10	66	3	0	0.11
Nathaniel Clyne	31	1991-04-05	Defender	1254	England	18	0	1	0	0	6	24	2	0	0.00
Nnamdi Ofoborh	22	1999-11-07	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Ryan Fraser	28	1994-02-24	Midfielder	3173	Scotland	38	7	14	0	0	10	61	2	0	0.20
Sam Surridge	24	1998-07-28	Forward	11	England	2	0	0	0	0	0	0	0	0	0.00
Simon Francis	37	1985-02-16	Defender	1226	England	17	0	2	0	0	5	23	1	0	0.00
Steve Cook	31	1991-04-19	Defender	2787	England	31	1	1	0	0	9	53	3	0	0.03
Tyrone Mings	29	1993-03-13	Defender	141	England	5	0	0	0	0	0	4	0	0	0.00

Arsenal

knitr::include_graphics(path = "./Arsenal.png")

ARS <- filter(df, current_club == "Arsenal") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(ARS, format = "html" ,caption = "Stats for Football Team Arsenal",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Arsenal
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aaron Ramsey	31	1990-12-26	Midfielder	1327	Wales	28	4	6	0	0	7	12	0	0	0.27
Ainsley Maitland-Niles	25	1997-08-29	Midfielder	985	England	16	1	1	0	0	4	16	3	1	0.09
Alex Iwobi	26	1996-05-03	Forward	1972	Nigeria	35	3	6	0	0	8	31	0	0	0.14
Alexandre Lacazette	31	1991-05-28	Forward	2503	France	35	13	8	0	0	7	28	2	0	0.47
Bernd Leno	30	1992-03-04	Goalkeeper	2835	Germany	32	0	0	0	0	7	39	0	0	0.00
Carl Jenkinson	30	1992-02-08	Defender	166	England	3	0	0	0	0	0	2	0	0	0.00
Damián Emiliano Martínez	30	1992-09-02	Goalkeeper	0	Argentina	0	0	0	0	0	0	0	0	0	0.00
Danny Welbeck	31	1990-11-26	Forward	147	England	8	1	1	0	0	2	2	0	0	0.61
Denis Suárez	28	1994-01-06	Midfielder	67	Spain	4	0	0	0	0	1	0	0	0	0.00
Edward Nketiah	23	1999-05-30	Forward	62	England	5	1	0	0	0	1	2	0	0	1.45
Emile Smith Rowe	22	2000-07-28	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Granit Xhaka	30	1992-09-27	Midfielder	2502	Switzerland	29	4	2	0	0	7	35	10	0	0.14
Hector Bellerin	27	1995-03-19	Defender	1535	Spain	19	0	5	0	0	4	20	3	0	0.00
Henrikh Mkhitaryan	33	1989-01-21	Midfielder	1643	Armenia	25	6	4	0	0	4	25	1	0	0.33
Joseph Willock	23	1999-08-20	Midfielder	64	England	2	0	0	0	0	0	0	0	0	0.00
Konstantinos Mavropanos	24	1997-12-11	Defender	150	Greece	4	0	0	0	0	1	1	1	0	0.00
Laurent Koscielny	37	1985-09-10	Defender	1328	France	17	3	0	0	0	4	21	1	0	0.20
Lucas Torreira	26	1996-02-11	Midfielder	2377	Uruguay	34	2	2	0	0	6	35	8	1	0.08
Mattéo Guendouzi Olié	23	1999-04-14	Midfielder	2143	France	33	0	0	0	0	4	28	9	0	0.00
Mesut Özil	34	1988-10-15	Midfielder	1741	Germany	24	5	2	0	0	6	23	2	0	0.26
Mohamed Elneny	30	1992-07-11	Midfielder	381	Egypt	8	0	0	0	0	2	4	0	0	0.00
Nacho Monreal	36	1986-02-26	Defender	1861	Spain	22	1	3	0	0	6	21	5	0	0.05
Petr Čech	40	1982-05-20	Goalkeeper	585	Czech Republic	7	0	0	0	0	2	8	0	0	0.00
Pierre-Emerick Aubameyang	33	1989-06-18	Forward	2731	Gabon	36	22	5	4	1	8	40	0	0	0.73
Rob Holding	27	1995-09-20	Defender	807	England	10	0	0	0	0	2	10	1	0	0.00
Sead Kolašinac	29	1993-06-20	Defender	1891	Bosnia and Herzegovina	24	0	5	0	0	5	26	5	0	0.00
Shkodran Mustafi	30	1992-04-17	Defender	2617	Germany	31	2	0	0	0	6	36	9	0	0.07
Sokratis Papastathopoulos	34	1988-06-09	Defender	2199	Greece	25	1	2	0	0	6	31	12	0	0.04
Stephan Lichtsteiner	38	1984-01-16	Defender	940	Switzerland	14	0	0	0	0	2	18	3	0	0.00
Zechariah Medley	22	2000-07-07	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00

Brighton & Hove Albion

knitr::include_graphics(path = "./Brighton&HoveAlbion.png")

BHA <- filter(df, current_club == "Brighton & Hove Albion") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(BHA, format = "html" ,caption = "Stats for Football Team Brighton & Hove Albion",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Brighton & Hove Albion
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Alireza Jahanbakhsh	29	1993-08-11	Forward	1022	Iran	19	0	0	0	0	4	16	2	0	0.00
Anthony Knockaert	30	1991-11-20	Midfielder	1832	France	30	2	6	0	0	3	36	5	1	0.10
Ben White	25	1997-10-08	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Beram Kayal	34	1988-05-02	Midfielder	934	Israel	18	1	1	0	0	5	15	4	0	0.10
Bernardo	27	1995-05-14	Defender	1750	Brazil	22	0	1	0	0	4	28	4	0	0.00
Bruno Saltor Grau	42	1980-10-01	Defender	1136	Spain	14	0	1	0	0	4	17	2	0	0.00
Dale Stephens	33	1989-06-12	Midfielder	2487	England	30	1	1	0	0	5	43	7	1	0.04
Dan Burn	30	1992-05-09	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
David Button	33	1989-02-27	Goalkeeper	360	England	4	0	0	0	0	1	5	0	0	0.00
Davy Pröpper	31	1991-09-02	Midfielder	2551	Netherlands	30	1	1	0	0	5	44	2	0	0.04
Florin Andone	29	1993-04-11	Forward	874	Romania	23	3	0	0	0	3	13	5	0	0.31
Gaëtan Bong Songo	34	1988-04-25	Defender	1805	Cameroon	22	0	0	0	0	5	32	0	0	0.00
Glenn Murray	39	1983-09-25	Forward	2513	England	38	13	1	4	0	7	44	5	0	0.47
Jason Steele	32	1990-08-18	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Jayson Molumby	23	1999-08-06	Midfielder	0	Republic of Ireland	0	0	0	0	0	0	0	0	0	0.00
Jose Izquierdo	30	1992-07-07	Forward	794	Colombia	15	0	1	0	0	5	8	1	0	0.00
Jürgen Locadia	28	1993-11-07	Forward	1227	Netherlands	26	2	0	0	0	4	19	1	0	0.15
Leon Balogun	34	1988-06-28	Defender	591	Nigeria	8	1	0	0	0	0	9	2	0	0.15
Lewis Dunk	30	1991-11-21	Defender	3153	England	36	2	1	0	0	7	53	7	1	0.06
Markus Suttner	35	1987-04-16	Defender	0	Austria	0	0	0	0	0	0	0	0	0	0.00
Martín Montoya	31	1991-04-14	Defender	2166	Spain	25	0	1	0	0	3	38	4	0	0.00
Mathew Ryan	30	1992-04-08	Goalkeeper	3060	Australia	34	0	0	0	0	6	52	2	0	0.00
Max Harrison Sanders	23	1999-01-04	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Pascal Groß	31	1991-06-15	Midfielder	1878	Germany	25	3	3	1	1	3	31	1	0	0.14
Shane Duffy	30	1992-01-01	Defender	3088	Republic of Ireland	35	5	1	0	0	7	51	5	1	0.15
Solomon March	28	1994-07-20	Midfielder	2473	England	35	1	5	0	0	6	39	1	0	0.04
Viktor Gyökeres	24	1998-06-04	Forward	0	Sweden	0	0	0	0	0	0	0	0	0	0.00
Yves Bissouma	26	1996-08-30	Midfielder	1769	Mali	28	0	0	0	0	5	30	5	0	0.00

Burnley

knitr::include_graphics(path = "./Burnley.png")

BNL <- filter(df, current_club == "Burnley") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(BNL, format = "html" ,caption = "Stats for Football Team Burnley",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Burnley
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aaron Lennon	35	1987-04-16	Midfielder	1217	England	16	1	1	0	4	20	1	0	0.07
Ali Koiki	22	2000-08-22	Defender	0	England	0	0	0	0	0	0	0	0	0.00
Anthony Driscoll-Glennon	22	1999-11-26	Defender	0	England	0	0	0	0	0	0	0	0	0.00
Ashley Barnes	32	1989-10-30	Forward	2400	England	37	12	2	2	8	34	8	0	0.45
Ashley Westwood	32	1990-04-01	Midfielder	2822	England	34	2	7	0	7	44	5	0	0.06
Ben Gibson	29	1993-01-15	Defender	63	England	1	1	0	0	0	3	1	0	1.43
Ben Mee	33	1989-09-21	Defender	3420	England	38	0	2	0	8	57	9	0	0.00
Charlie Taylor	29	1993-09-18	Defender	3240	England	38	0	1	0	8	53	2	0	0.00
Chris Wood	30	1991-12-07	Forward	2582	New Zealand	38	10	2	0	8	43	2	0	0.35
Dwight McNeil	22	1999-11-22	Forward	1599	England	21	3	5	0	4	22	2	0	0.17
Jack Cork	33	1989-06-25	Midfielder	3313	England	37	1	2	0	8	54	6	0	0.03
James Tarkowski	29	1992-11-19	Defender	3087	England	35	3	1	0	7	52	8	0	0.09
Jeff Hendrick	30	1992-01-31	Midfielder	2069	Republic of Ireland	32	3	0	0	6	41	4	0	0.13
Joe Hart	35	1987-04-19	Goalkeeper	1710	England	19	0	0	0	4	34	0	0	0.00
Johann Berg Guðmundsson	32	1990-10-27	Midfielder	1748	Iceland	29	3	6	0	6	31	2	0	0.15
Jonathan Walters	39	1983-09-20	Forward	0	Republic of Ireland	0	0	0	0	0	0	0	0	0.00
Josh Benson	22	1999-12-05	Midfielder	0	England	0	0	0	0	0	0	0	0	0.00
Kevin Long	32	1990-08-18	Defender	513	Republic of Ireland	6	0	1	0	1	7	0	0	0.00
Matěj Vydra	30	1992-05-01	Forward	311	Czech Republic	13	1	1	0	1	4	1	0	0.29
Matthew Lowton	33	1989-06-09	Defender	1748	England	21	0	0	0	4	35	7	0	0.00
Peter Crouch	41	1981-01-30	Forward	86	England	6	0	0	0	0	0	1	0	0.00
Phil Bardsley	37	1985-06-28	Defender	1672	Scotland	19	0	0	0	4	22	9	0	0.00
Robbie Brady	30	1992-01-14	Midfielder	715	Republic of Ireland	16	0	1	0	2	12	4	1	0.00
Sam Vokes	33	1989-10-21	Forward	913	Wales	20	3	0	0	4	18	0	0	0.30
Stephen Ward	37	1985-08-20	Defender	230	Republic of Ireland	3	0	0	0	1	6	1	0	0.00
Steven Defour	34	1988-04-15	Midfielder	452	Belgium	6	0	0	0	1	12	0	0	0.00
Tom Heaton	36	1986-04-15	Goalkeeper	1710	England	19	0	0	0	4	23	3	0	0.00

Cardiff City

knitr::include_graphics(path = "./CardiffCity.png")

CFC <- filter(df, current_club == "Cardiff City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CFC, format = "html" ,caption = "Stats for Football Team Cardiff City",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Cardiff City
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Alex Smithies	32	1990-03-05	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Aron Einar Gunnarsson	33	1989-04-22	Midfielder	2274	Iceland	28	1	1	0	0	8	37	5	0	0.04
Bobby Reid	29	1993-02-02	Midfielder	1422	England	27	5	2	1	0	6	27	0	0	0.32
Brian Murphy	39	1983-05-07	Goalkeeper	0	Republic of Ireland	0	0	0	0	0	0	0	0	0	0.00
Bruno Écuélé Manga	34	1988-07-16	Defender	3375	Gabon	38	0	1	0	0	10	59	0	0	0.00
Callum Paterson	28	1994-10-13	Defender	1996	Scotland	27	4	1	0	0	7	37	4	0	0.18
Danny Ward	31	1990-12-09	Forward	440	England	14	1	0	0	0	2	11	0	0	0.20
David Junior Hoilett	32	1990-06-05	Forward	2142	Canada	32	3	1	0	0	9	42	4	0	0.13
Gary Madine	32	1990-08-24	Forward	32	England	5	0	0	0	0	0	2	0	0	0.00
Greg Cunningham	31	1991-01-31	Defender	630	Republic of Ireland	7	0	0	0	0	1	16	3	0	0.00
Harry Arter	32	1989-12-28	Midfielder	2008	Republic of Ireland	25	0	1	0	0	7	37	10	0	0.00
Jazz Richards	31	1991-04-12	Defender	128	Wales	4	0	0	0	0	1	4	0	0	0.00
Joe Bennett	32	1990-03-28	Defender	2641	England	30	0	1	0	0	9	43	5	0	0.00
Joe Ralls	29	1993-10-13	Midfielder	1959	England	28	0	0	0	1	8	35	5	1	0.00
Josh Murphy	27	1995-02-24	Forward	1825	England	29	3	2	0	0	7	27	2	0	0.15
Kadeem Harris	29	1993-06-08	Midfielder	366	England	13	1	0	0	0	4	5	1	0	0.25
Kenneth Dahrup Zohorè	28	1994-01-31	Forward	746	Denmark	19	1	1	0	0	5	15	1	0	0.12
Leandro Bacuna	31	1991-08-21	Midfielder	554	Curaçao	11	0	0	0	0	4	11	2	0	0.00
Lee Peltier	35	1986-12-11	Defender	1542	England	20	0	0	0	0	6	21	4	0	0.00
Loïc Damour	31	1991-01-08	Midfielder	21	France	2	0	0	0	0	0	2	0	0	0.00
Matthew Connolly	35	1987-09-24	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Nathaniel Mendez-Laing	30	1992-04-15	Midfielder	984	England	20	4	1	1	0	6	15	0	0	0.37
Neil Leonard Dula Etheridge	32	1990-02-07	Goalkeeper	3420	Philippines	38	0	0	0	0	10	61	2	0	0.00
Oumar Niasse	32	1990-04-18	Forward	998	Senegal	18	0	0	0	0	3	12	0	0	0.00
Rhys Healey	27	1994-12-06	Forward	49	England	3	0	0	0	0	1	1	0	0	0.00
Sean Morrison	31	1991-01-08	Defender	3040	England	34	1	3	0	0	9	57	6	0	0.03
Souleymane Bamba	37	1985-01-13	Defender	2475	Ivory Coast	28	4	1	0	0	7	46	7	0	0.15
Víctor Camarasa	28	1994-05-28	Midfielder	2579	Spain	32	5	4	1	0	8	48	6	0	0.17

Chelsea

knitr::include_graphics(path = "./Chelsea.png")

CHS <- filter(df, current_club == "Chelsea") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CHS, format = "html" ,caption = "Stats for Football Team Chelsea",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Chelsea
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	goals_per_90_overall
Alvaro Morata	30	1992-10-23	Forward	943	Spain	16	5	0	0	9	11	3	0.48
Andreas Christensen	26	1996-04-10	Defender	615	Denmark	8	0	0	0	3	7	1	0.00
Antonio Rüdiger	29	1993-03-03	Defender	2874	Germany	33	1	0	0	12	34	7	0.03
Callum Hudson-Odoi	21	2000-11-07	Midfielder	391	England	10	0	1	0	3	5	0	0.00
Cesar Azpilicueta	33	1989-08-28	Defender	3403	Spain	38	1	5	0	16	38	4	0.03
Cesc Fabregas	35	1987-05-04	Midfielder	175	Spain	6	0	0	0	3	2	1	0.00
Danny Drinkwater	32	1990-03-05	Midfielder	0	England	0	0	0	0	0	0	0	0.00
David Luiz	35	1987-04-22	Defender	3239	Brazil	36	3	2	0	16	35	3	0.08
Davide Zappacosta	30	1992-06-11	Defender	125	Italy	4	0	0	0	3	0	0	0.00
Eden Hazard	31	1991-01-07	Midfielder	2926	Belgium	37	16	15	4	15	34	2	0.49
Emerson Palmieri dos Santos	28	1994-08-03	Defender	660	Italy	10	0	0	0	3	10	0	0.00
Ethan Ampadu	22	2000-09-14	Midfielder	0	Wales	0	0	0	0	0	0	0	0.00
Gary Cahill	36	1985-12-19	Defender	22	England	2	0	0	0	2	0	0	0.00
Gonzalo Higuain	34	1987-12-10	Forward	1092	Argentina	14	5	0	0	5	15	0	0.41
Jorginho	30	1991-12-20	Midfielder	3165	Italy	37	2	0	1	16	36	8	0.06
Kepa Arrizabalaga	28	1994-10-03	Goalkeeper	3240	Spain	36	0	0	0	14	38	2	0.00
Marc Guehi	22	2000-07-13	Defender	0	England	0	0	0	0	0	0	0	0.00
Marcos Alonso	31	1990-12-28	Defender	2761	Spain	31	2	4	0	14	28	6	0.07
Mateo Kovačić	28	1994-05-06	Midfielder	1743	Croatia	32	0	2	0	12	18	3	0.00
N’Golo Kanté	31	1991-03-29	Midfielder	3096	France	36	4	4	0	15	37	3	0.12
Olivier Giroud	36	1986-09-30	Forward	832	France	27	2	4	0	12	4	1	0.22
Pedro Rodriguez	35	1987-07-28	Midfielder	1780	Spain	31	8	2	0	11	18	2	0.40
Ross Barkley	28	1993-12-05	Midfielder	1241	England	27	3	5	0	11	13	1	0.22
Ruben Loftus-Cheek	26	1996-01-23	Midfielder	983	England	24	6	2	0	12	8	0	0.55
Victor Moses	31	1990-12-12	Midfielder	26	Nigeria	2	0	0	0	1	1	0	0.00
Wilfredo Daniel Caballero	41	1981-09-28	Goalkeeper	180	Argentina	2	0	0	0	2	0	0	0.00
Willian	34	1988-08-09	Forward	2108	Brazil	32	3	6	0	13	23	2	0.13

Crystal Palace

knitr::include_graphics(path = "./CrystalPalace.png")

CRP <- filter(df, current_club == "Crystal Palace") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CRP, format = "html" ,caption = "Stats for Football Team Crystal Palace",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Crystal Palace
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aaron Wan-Bissaka	24	1997-11-26	Midfielder	3135	England	35	0	3	0	0	12	41	5	1	0.00
Alexander Sørloth	26	1995-12-05	Forward	173	Norway	12	0	0	0	0	4	1	0	0	0.00
Andros Townsend	31	1991-07-16	Midfielder	3018	England	38	6	4	0	0	12	44	1	0	0.18
Bakary Sako	34	1988-04-26	Midfielder	25	Mali	4	0	0	0	0	1	0	0	0	0.00
Cheikhou Kouyaté	32	1989-12-21	Midfielder	1897	Senegal	31	0	2	0	0	11	24	3	0	0.00
Christian Benteke	31	1990-12-03	Forward	813	Belgium	16	1	1	0	0	5	10	1	0	0.11
Connor Wickham	29	1993-03-31	Forward	61	England	6	0	1	0	0	2	0	0	0	0.00
Jaïro Riedewald	26	1996-09-09	Defender	0	Netherlands	0	0	0	0	0	0	0	0	0	0.00
James McArthur	35	1987-10-07	Midfielder	3071	Scotland	38	3	6	0	0	12	44	7	0	0.09
James Tomkins	33	1989-03-29	Defender	2563	England	29	1	1	0	0	10	34	6	0	0.04
Jeffrey Schlupp	29	1992-12-23	Defender	1665	Ghana	30	4	1	0	0	8	24	1	0	0.22
Joe Daniel Tupper	24	1997-11-15	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Joel Ward	32	1989-10-29	Defender	551	England	7	1	0	0	0	0	12	1	0	0.16
Jordan Ayew	31	1991-09-11	Forward	1186	Ghana	20	1	2	0	0	6	13	3	0	0.08
Julián Speroni	43	1979-05-18	Goalkeeper	90	Argentina	1	0	0	0	0	0	3	0	0	0.00
Luka Milivojević	31	1991-04-07	Midfielder	3420	Serbia	38	12	2	10	1	12	47	10	0	0.32
Luke Dreher	23	1998-11-27	Midfielder	0	England	1	0	0	0	0	0	0	0	0	0.00
Mamadou Sakho	32	1990-02-13	Defender	2417	France	27	0	0	0	0	9	32	2	0	0.00
Martin Kelly	32	1990-04-27	Defender	1110	England	13	0	0	0	0	3	18	2	0	0.00
Max Meyer	27	1995-09-18	Midfielder	1414	Germany	29	1	2	0	0	8	19	3	0	0.06
Michy Batshuayi	29	1993-10-02	Forward	756	Belgium	11	5	0	0	0	3	11	0	0	0.60
Nikola Tavares	23	1999-01-17	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Pape N’Diaye Souaré	32	1990-06-06	Defender	0	Senegal	1	0	0	0	0	1	0	0	0	0.00
Patrick van Aanholt	32	1990-08-29	Defender	3198	Netherlands	36	3	2	0	0	12	41	3	0	0.08
Sam Woods	24	1998-09-11	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Scott Dann	35	1987-02-14	Defender	660	England	10	0	1	0	0	3	7	1	0	0.00
Sullay Kaikai	27	1995-08-26	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Vicente Guaita	35	1987-01-10	Goalkeeper	1755	Spain	20	0	0	0	0	7	21	2	0	0.00
Wayne Hennessey	35	1987-01-24	Goalkeeper	1575	Wales	18	0	0	0	0	5	23	0	0	0.00
Wilfried Zaha	29	1992-11-10	Midfielder	3041	Ivory Coast	34	10	5	0	0	10	45	10	1	0.30

Everton

knitr::include_graphics(path = "./Everton.png")

EVN <- filter(df, current_club == "Everton") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(EVN, format = "html" ,caption = "Stats for Football Team Everton",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Everton
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Ademola Lookman	25	1997-10-20	Forward	601	England	21	0	2	0	0	8	7	0	0	0.00
André Filipe Tavares Gomes	29	1993-07-30	Midfielder	1986	Portugal	27	1	1	0	0	10	27	7	0	0.05
Bernard Anício Caldeira Duarte	30	1992-09-08	Midfielder	2128	Brazil	34	1	3	0	0	14	19	5	0	0.04
Cenk Tosun	31	1991-06-07	Forward	1050	Turkey	25	3	3	0	0	7	16	3	0	0.26
Dominic Calvert-Lewin	25	1997-03-16	Forward	1774	England	35	6	2	0	0	13	24	3	0	0.30
Gylfi Sigurdsson	33	1989-09-08	Midfielder	3134	Iceland	38	13	6	2	3	14	40	3	0	0.37
Idrissa Gana Gueye	33	1989-09-26	Midfielder	2825	Senegal	33	0	2	0	0	13	29	6	0	0.00
James McCarthy	31	1990-11-12	Midfielder	14	Republic of Ireland	1	0	0	0	0	1	0	0	0	0.00
Jonjoe Kenny	25	1997-03-15	Defender	790	England	10	0	1	0	0	2	14	1	0	0.00
Jordan Pickford	28	1994-03-07	Goalkeeper	3420	England	38	0	0	0	0	14	44	1	0	0.00
Kieran Dowell	25	1997-10-10	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Kurt Zouma	28	1994-10-27	Defender	2610	France	32	2	2	0	0	11	37	5	1	0.07
Leighton Baines	37	1984-12-11	Defender	376	England	6	0	0	0	0	1	6	0	0	0.00
Lucas Digne	29	1993-07-20	Defender	2990	France	35	4	4	0	0	14	36	6	1	0.12
Maarten Stekelenburg	40	1982-09-22	Goalkeeper	0	Netherlands	0	0	0	0	0	0	0	0	0	0.00
Mason Holgate	26	1996-10-22	Defender	407	England	5	0	0	0	0	0	9	1	0	0.00
Michael Keane	29	1993-01-11	Defender	2970	England	33	1	2	0	0	13	37	2	0	0.03
Morgan Schneiderlin	32	1989-11-08	Midfielder	833	France	14	0	1	0	0	7	9	2	0	0.00
Phil Jagielka	40	1982-08-17	Defender	329	England	7	1	0	0	0	5	2	1	1	0.27
Richarlison de Andrade	25	1997-05-10	Forward	2679	Brazil	35	13	1	0	0	14	32	6	1	0.44
Sandro Ramirez	27	1995-07-09	Forward	0	Spain	0	0	0	0	0	0	0	0	0	0.00
Séamus Coleman	34	1988-10-11	Defender	2560	Republic of Ireland	29	2	2	0	0	13	29	1	0	0.07
Theo Walcott	33	1989-03-16	Forward	2122	England	37	5	2	0	0	13	33	1	0	0.21
Tom Davies	24	1998-06-30	Midfielder	975	England	16	0	0	0	0	5	18	3	0	0.00
Tyias Browning	28	1994-05-27	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Yerry Fernando Mina González	28	1994-09-23	Defender	890	Colombia	13	1	0	0	0	4	12	3	0	0.10

Fulham

knitr::include_graphics(path = "./Fulham.png")

FLM <- filter(df, current_club == "Fulham") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(FLM, format = "html" ,caption = "Stats for Football Team Fulham",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Fulham
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aboubakar Kamara	27	1995-03-07	Forward	687	France	13	3	0	1	1	2	16	2	0	0.39
Aleksandar Mitrović	28	1994-09-16	Forward	3282	Serbia	37	11	3	1	0	5	74	7	0	0.30
Alfie Mawson	28	1994-01-19	Defender	1131	England	15	0	0	0	0	3	25	2	0	0.00
André Schürrle	31	1990-11-06	Midfielder	1650	Germany	24	6	0	0	0	1	42	2	0	0.33
André-Frank Zambo Anguissa	26	1995-11-16	Midfielder	1518	Cameroon	22	0	0	0	0	3	30	3	1	0.00
Calum Chambers	27	1995-01-20	Defender	2587	England	31	2	0	0	0	5	49	9	0	0.07
Cyrus Christie	30	1992-09-30	Defender	1943	Republic of Ireland	28	0	1	0	0	5	40	7	0	0.00
Denis Odoi	34	1988-05-27	Defender	2593	Belgium	31	0	1	0	0	5	59	4	0	0.00
Fabricio Martín Agosto Ramírez	34	1987-12-31	Goalkeeper	180	Spain	2	0	0	0	0	0	5	0	0	0.00
Floyd Ayité	33	1988-12-15	Midfielder	465	Togo	16	1	0	0	0	3	13	0	0	0.19
Håvard Nordtveit	32	1990-06-21	Midfielder	361	Norway	5	0	1	0	0	1	9	0	0	0.00
Ibrahima Cissé	28	1994-02-28	Midfielder	87	Belgium	3	0	0	0	0	0	3	0	0	0.00
Jean Michau00ebl Seri	31	1991-07-19	Midfielder	2252	Ivory Coast	32	1	2	0	0	4	53	6	0	0.04
Joe Bryan	29	1993-09-17	Defender	2350	England	28	0	1	0	0	5	51	5	0	0.00
Kevin McDonald	33	1988-11-04	Midfielder	842	Scotland	15	0	0	0	0	0	25	6	1	0.00
Lazar Marković	28	1994-03-02	Midfielder	44	Serbia	1	0	0	0	0	0	0	0	0	0.00
Luca de la Torre	24	1998-05-23	Midfielder	0	USA	0	0	0	0	0	0	0	0	0	0.00
Luciano Vietto	28	1993-12-05	Forward	983	Argentina	20	1	4	0	0	1	21	1	0	0.09
Marcus Bettinelli	30	1992-05-24	Goalkeeper	630	England	7	0	0	0	0	0	19	1	0	0.00
Maxime Le Marchand	33	1989-10-11	Defender	2251	France	26	0	1	0	0	4	50	5	0	0.00
Neeskens Kebano	30	1992-03-10	Midfielder	103	Congo DR	7	0	0	0	0	0	1	0	0	0.00
Ryan Guno Babel	35	1986-12-19	Forward	1260	Netherlands	16	5	3	0	0	3	24	3	0	0.36
Ryan Sessegnon	22	2000-05-18	Defender	2298	England	35	2	6	0	0	4	58	0	0	0.08
Sergio Rico	29	1993-09-01	Goalkeeper	2610	Spain	29	0	0	0	0	5	53	1	0	0.00
Stefan Marius Johansen	31	1991-01-08	Midfielder	412	Norway	12	0	0	0	0	0	11	4	0	0.00
Tim Ream	35	1987-10-05	Defender	2051	USA	26	0	0	0	0	5	47	1	0	0.00
Timothy Fosu-Mensah	24	1998-01-02	Defender	795	Netherlands	12	0	0	0	0	1	18	3	0	0.00
Tom Cairney	31	1991-01-20	Midfielder	2198	Scotland	31	1	1	0	0	4	49	0	0	0.04
Zeze Steven Sessegnon	22	2000-05-18	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00

Huddersfield Town

knitr::include_graphics(path = "./Huddersfield_Town.png")

HFT <- filter(df, current_club == "Huddersfield Town") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(HFT, format = "html" ,caption = "Stats for Football Team Huddersfield Town",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Huddersfield Town
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aaron Mooy	32	1990-09-15	Midfielder	2327	Australia	29	3	1	1	4	46	4	0	0.12
Aaron Rowe	22	2000-09-07	Forward	69	England	2	0	0	0	0	1	0	0	0.00
Abdelhamid Sabiri	25	1996-11-28	Midfielder	49	Morocco	2	0	0	0	0	3	0	0	0.00
Adama Diakhaby	26	1996-07-05	Forward	551	France	12	0	0	0	1	16	1	0	0.00
Alex Pritchard	29	1993-05-03	Midfielder	2092	England	30	2	0	0	4	39	2	0	0.09
Ben Hamer	34	1987-11-20	Goalkeeper	553	England	7	0	0	0	1	20	0	0	0.00
Chris Löwe	33	1989-04-16	Defender	2056	Germany	29	0	2	0	1	52	2	0	0.00
Christopher Schindler	32	1990-04-29	Defender	3262	Germany	37	1	0	0	5	69	6	1	0.03
Collin Quaner	31	1991-06-18	Forward	37	Germany	2	0	0	0	0	2	0	0	0.00
Daniel Williams	33	1989-03-08	Midfielder	93	USA	5	0	0	0	1	1	1	0	0.00
Demeaco Duhaney	24	1998-10-13	Defender	46	England	1	0	0	0	1	0	0	0	0.00
Elias Kachunga	30	1992-04-22	Forward	1181	Congo DR	20	0	0	0	2	28	2	0	0.00
Erik Durm	30	1992-05-12	Defender	2052	Germany	28	0	1	0	3	43	0	0	0.00
Florent Hadergjonaj	28	1994-07-31	Defender	1840	Switzerland	24	0	0	0	4	34	1	0	0.00
Isaac Mbenza	26	1996-03-08	Forward	981	Belgium	22	1	1	0	4	25	1	0	0.09
Jason Puncheon	36	1986-06-26	Midfielder	391	England	11	0	0	0	3	8	1	0	0.00
Joel Coleman	27	1995-09-26	Goalkeeper	90	England	1	0	0	0	0	1	0	0	0.00
Jon Gorenc Stankovič	26	1996-01-14	Defender	718	Slovenia	11	1	0	0	2	19	2	0	0.13
Jonas Lössl	33	1989-02-01	Goalkeeper	2777	Denmark	31	0	1	0	5	52	1	0	0.00
Jonathan Hogg	33	1988-12-06	Midfielder	2377	England	29	0	1	0	5	42	9	1	0.00
Juninho Bacuna	25	1997-08-07	Midfielder	1414	Netherlands	21	1	0	0	2	36	4	0	0.06
Karlan Ahearne-Grant	24	1997-12-19	Forward	874	England	13	4	0	0	1	22	0	0	0.41
Laurent Depoitre	33	1988-12-07	Forward	1059	Belgium	23	0	1	0	3	22	1	0	0.00
Mathias Jattah-Njie Jørgensen	32	1990-04-23	Defender	2148	Denmark	24	3	1	0	3	37	6	0	0.13
Matty Daly	21	2001-03-10	Midfielder	73	England	2	0	0	0	0	1	0	0	0.00
Philip Billing	26	1996-06-11	Midfielder	2192	Denmark	27	2	0	0	5	41	7	0	0.08
Rajiv van La Parra	31	1991-06-04	Midfielder	407	Netherlands	5	0	0	0	1	6	0	0	0.00
Ramadan Sobhi	25	1997-01-23	Forward	75	Egypt	4	0	0	0	0	1	0	0	0.00
Ryan Schofield	22	1999-12-11	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0.00
Steve Mounié	28	1994-09-29	Forward	1777	Benin	31	2	3	0	5	34	2	1	0.10
Terence Kongolo	28	1994-02-14	Defender	2722	Netherlands	32	1	1	0	4	62	4	0	0.03
Tom Smith	30	1992-04-14	Defender	1141	England	15	0	0	0	1	34	3	1	0.00

Leicester City

knitr::include_graphics(path = "./Leicester_City.png")

LSC <- filter(df, current_club == "Leicester City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(LSC, format = "html" ,caption = "Stats for Football Team Leicester City",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Leicester City
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Adrien Sebastian Perruchet Silva	33	1989-03-15	Midfielder	88	Portugal	2	0	0	0	0	1	1	0	0	0.00
Ben Chilwell	25	1996-12-21	Defender	3240	England	36	0	4	0	0	10	39	4	0	0.00
Caglar Söyüncü	26	1996-05-23	Defender	371	Turkey	6	0	0	0	0	2	3	1	0	0.00
Christian Fuchs	36	1986-04-07	Defender	206	Austria	3	0	0	0	0	0	4	0	0	0.00
Daniel Amartey	27	1994-12-21	Midfielder	640	Ghana	9	0	0	0	0	2	9	2	0	0.00
Danny Simpson	35	1987-01-04	Defender	291	England	6	0	0	0	0	3	4	0	0	0.00
Danny Ward	29	1993-06-22	Goalkeeper	0	Wales	0	0	0	0	0	0	0	0	0	0.00
Demarai Gray	26	1996-06-28	Midfielder	1992	England	34	4	1	0	0	8	26	2	0	0.18
Fousseni Diabaté	27	1995-10-18	Midfielder	55	Mali	1	0	0	0	0	0	1	0	0	0.00
Hamza Choudhury	25	1997-10-01	Midfielder	596	England	9	0	0	0	0	4	4	0	0	0.00
Harry Maguire	29	1993-03-05	Defender	2599	England	31	3	0	0	0	7	36	7	1	0.10
Harvey Lewis Barnes	24	1997-12-09	Midfielder	1007	England	16	1	2	0	0	3	16	0	0	0.09
James Maddison	25	1996-11-23	Midfielder	2850	England	36	7	7	1	1	8	39	5	1	0.22
Jamie Vardy	35	1987-01-11	Forward	2735	England	34	18	4	4	1	10	33	4	1	0.59
Jonny Evans	34	1988-01-03	Defender	1995	Northern Ireland	24	1	0	0	0	8	22	2	0	0.05
Josh Knight	25	1997-09-07	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Kasper Schmeichel	35	1986-11-05	Goalkeeper	3420	Denmark	38	0	0	0	0	10	43	3	0	0.00
Kelechi Iheanacho	26	1996-10-03	Forward	926	Nigeria	30	1	3	0	0	6	11	2	0	0.10
Marc Albrighton	32	1989-11-18	Midfielder	1626	England	27	2	2	0	0	9	17	3	0	0.11
Nampalys Mendy	30	1992-06-23	Midfielder	2088	France	31	0	0	0	0	9	26	5	0	0.00
Onyinye Wilfred Ndidi	25	1996-12-16	Midfielder	3299	Nigeria	38	2	0	0	0	10	42	8	0	0.05
Rachid Ghezzal	30	1992-05-09	Forward	738	Algeria	19	1	0	0	0	3	12	3	0	0.12
Ricardo Domingos Barbosa Pereira	29	1993-10-06	Defender	3125	Portugal	35	2	6	0	0	10	40	7	0	0.06
Shinji Okazaki	36	1986-04-16	Forward	269	Japan	21	0	1	0	0	2	1	0	0	0.00
Vicente Iborra De La Fuente	34	1988-01-16	Midfielder	226	Spain	8	0	0	0	0	3	4	0	0	0.00
Wes Morgan	38	1984-01-21	Defender	1926	Jamaica	22	3	0	0	0	6	24	5	2	0.14
Youri Tielemans	25	1997-05-07	Midfielder	1092	Belgium	13	3	4	0	0	3	13	2	0	0.25

Liverpool

knitr::include_graphics(path = "./Liverpool_FC.png")

LVP <- filter(df, current_club == "Liverpool") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(LVP, format = "html" ,caption = "Stats for Football Team Liverpool ",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Liverpool
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Adam David Lallana	34	1988-05-10	Midfielder	465	England	13	0	0	0	6	2	1	0	0.00
Alberto Moreno	30	1992-07-05	Defender	155	Spain	2	0	0	0	0	2	0	0	0.00
Alex Oxlade-Chamberlain	29	1993-08-15	Midfielder	19	England	2	0	0	0	2	0	0	0	0.00
Alisson Becker	30	1992-10-02	Goalkeeper	3420	Brazil	38	0	0	0	21	19	1	0	0.00
Andrew Robertson	28	1994-03-11	Defender	3219	Scotland	36	0	11	0	21	17	4	0	0.00
Curtis Jones	21	2001-01-30	Midfielder	0	England	0	0	0	0	0	0	0	0	0.00
Daniel Sturridge	33	1989-09-01	Forward	496	England	18	2	1	0	10	3	1	0	0.36
Dejan Lovren	33	1989-07-05	Defender	985	Croatia	13	1	0	0	6	7	1	0	0.09
Divock Origi	27	1995-04-18	Forward	366	Belgium	12	3	1	0	7	2	0	0	0.74
Fabinho	29	1993-10-23	Midfielder	2013	Brazil	28	1	2	0	15	13	6	0	0.04
Georginio Wijnaldum	31	1990-11-11	Midfielder	2735	Netherlands	35	3	0	0	21	15	3	0	0.10
James Milner	36	1986-01-04	Midfielder	1785	England	31	5	4	3	18	11	7	1	0.25
Joe Gomez	25	1997-05-23	Defender	1060	England	16	0	0	0	11	3	2	0	0.00
Joel Matip	31	1991-08-08	Defender	1532	Cameroon	22	1	0	0	11	9	3	0	0.06
Jordan Henderson	32	1990-06-17	Midfielder	1983	England	32	1	3	0	19	11	3	1	0.05
Loris Karius	29	1993-06-22	Goalkeeper	0	Germany	0	0	0	0	0	0	0	0	0.00
Mohamed Salah	30	1992-06-15	Forward	3262	Egypt	38	22	8	3	21	18	1	0	0.61
Naby Deco Keïta	27	1995-02-10	Midfielder	1392	Guinea	25	2	1	0	15	7	0	0	0.13
Rafael Euclides Soares Camacho	22	2000-05-22	Midfielder	0	Portugal	1	0	0	0	0	0	0	0	0.00
Roberto Firmino	31	1991-10-02	Forward	2620	Brazil	34	12	6	1	18	13	0	0	0.41
Sadio Mané	30	1992-04-10	Forward	3086	Senegal	36	22	1	0	20	18	2	0	0.64
Simon Mignolet	34	1988-03-06	Goalkeeper	0	Belgium	0	0	0	0	0	0	0	0	0.00
Trent Alexander-Arnold	24	1998-10-07	Defender	2467	England	29	1	12	0	16	14	3	0	0.04
Virgil van Dijk	31	1991-07-08	Defender	3385	Netherlands	38	4	2	0	21	19	1	0	0.11
Xherdan Shaqiri	31	1991-10-10	Midfielder	1058	Switzerland	24	6	3	0	12	5	2	0	0.51

Manchester City

knitr::include_graphics(path = "./Manchester_City.png")

MCC <- filter(df, current_club == "Manchester City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(MCC, format = "html" ,caption = "Stats for Football Team Manchester City",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Manchester City
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Arijanet Muric	23	1998-11-07	Goalkeeper	0	Montenegro	0	0	0	0	0	0	0	0	0	0.00
Aymeric Laporte	28	1994-05-27	Defender	3057	France	35	3	3	0	0	18	21	3	0	0.09
Benjamin Mendy	28	1994-07-17	Defender	900	France	10	0	5	0	0	4	6	1	0	0.00
Bernardo Silva	28	1994-08-10	Midfielder	2853	Portugal	36	7	7	0	0	18	22	3	0	0.22
Claudio Andrés Bravo Muñoz	39	1983-04-13	Goalkeeper	0	Chile	0	0	0	0	0	0	0	0	0	0.00
Danilo	31	1991-07-15	Defender	806	Brazil	11	1	0	0	0	5	7	1	0	0.11
David Silva	36	1986-01-08	Midfielder	2411	Spain	33	6	8	0	0	17	14	3	0	0.22
Ederson	29	1993-08-17	Goalkeeper	3420	Brazil	38	0	1	0	0	20	23	2	0	0.00
Fabian Delph	32	1989-11-21	Midfielder	725	England	11	0	1	0	0	4	9	2	1	0.00
Fernando Luiz Rosa	37	1985-05-04	Midfielder	2381	Brazil	29	1	3	0	0	16	15	5	0	0.04
Gabriel Jesus	25	1997-04-03	Forward	1019	Brazil	29	7	3	1	0	16	11	1	0	0.62
İlkay Gündoğan	32	1990-10-24	Midfielder	2135	Germany	31	6	3	0	0	15	15	3	0	0.25
John Stones	28	1994-05-28	Defender	1762	England	24	0	0	0	0	13	15	1	0	0.00
Kevin De Bruyne	31	1991-06-28	Midfielder	974	Belgium	19	2	2	0	0	12	3	2	0	0.18
Kyle Walker	32	1990-05-28	Defender	2777	England	33	1	1	0	0	18	17	3	0	0.03
Leroy Sané	26	1996-01-11	Midfielder	1867	Germany	31	10	10	0	0	16	14	1	0	0.48
Nicolas Otamendi	34	1988-02-12	Defender	1233	Argentina	18	0	0	0	0	10	7	1	0	0.00
Oleksandr Zinchenko	25	1996-12-15	Midfielder	1153	Ukraine	14	0	3	0	0	10	4	1	0	0.00
Philip Foden	22	2000-05-28	Midfielder	327	England	13	1	0	0	0	8	0	0	0	0.28
Philippe Sandler	25	1997-02-10	Defender	0	Netherlands	0	0	0	0	0	0	0	0	0	0.00
Raheem Sterling	27	1994-12-08	Forward	2777	England	34	17	10	0	0	18	19	3	0	0.55
Riyad Mahrez	31	1991-02-21	Midfielder	1339	Algeria	27	7	4	0	1	13	9	0	0	0.47
Sergio Aguero	34	1988-06-02	Forward	2480	Argentina	33	21	8	2	0	19	15	3	0	0.76
Vincent Kompany	36	1986-04-10	Defender	1223	Belgium	17	1	0	0	0	7	7	6	0	0.07

Manchester United

knitr::include_graphics(path = "./Manchester_United.png")

MCU <- filter(df, current_club == "Manchester United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(MCU, format = "html" ,caption = "Stats for Football Team Manchester United",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Manchester United
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Alexis Sanchez	33	1988-12-19	Forward	877	Chile	20	1	3	0	0	6	8	3	0	0.10
Ander Herrera	33	1989-08-14	Midfielder	1404	Spain	22	2	3	0	0	6	17	4	0	0.13
Andreas Pereira	26	1996-01-01	Midfielder	595	Brazil	15	1	1	0	0	1	10	5	0	0.15
Angel Gomes	22	2000-08-31	Midfielder	25	England	2	0	0	0	0	0	1	0	0	0.00
Anthony Martial	26	1995-12-05	Forward	1623	France	27	10	2	1	0	5	25	2	0	0.55
Antonio Valencia	37	1985-08-04	Defender	466	Ecuador	6	0	0	0	0	2	5	2	0	0.00
Ashley Young	37	1985-07-09	Midfielder	2568	England	30	2	2	0	0	4	41	10	1	0.07
Chris Smalling	32	1989-11-22	Defender	2128	England	24	1	0	0	0	4	34	1	0	0.04
David de Gea	31	1990-11-07	Goalkeeper	3420	Spain	38	0	0	0	0	7	51	1	0	0.00
Eric Bertrand Bailly	28	1994-04-12	Defender	637	Ivory Coast	12	0	0	0	0	3	12	1	1	0.00
Faustino Marcos Alberto Rojo	32	1990-03-20	Defender	211	Argentina	5	0	0	0	0	0	4	2	0	0.00
Frederico Rodrigues Santos	29	1993-03-05	Midfielder	1045	Brazil	17	1	1	0	0	0	19	2	0	0.09
James Garner	21	2001-03-13	Defender	0	England	1	0	0	0	0	0	0	0	0	0.00
Jesse Lingard	29	1992-12-15	Midfielder	1668	England	27	4	2	1	0	6	25	3	0	0.22
José Diogo Dalot Teixeira	23	1999-03-18	Defender	1015	Portugal	16	0	2	0	0	2	18	3	0	0.00
Juan Mata	34	1988-04-28	Midfielder	1294	Spain	22	3	2	0	0	4	14	3	0	0.21
Lee Grant	39	1983-01-27	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Luke Shaw	27	1995-07-12	Defender	2592	England	29	1	4	0	0	6	36	11	0	0.03
Marcus Rashford	25	1997-10-31	Forward	2362	England	33	10	6	0	0	6	34	4	1	0.38
Marouane Fellaini	34	1987-11-22	Midfielder	744	Belgium	14	0	1	0	0	2	13	1	0	0.00
Mason Greenwood	21	2001-10-01	Midfielder	115	England	3	0	0	0	0	0	2	0	0	0.00
Matteo Darmian	32	1989-12-02	Defender	443	Italy	6	0	0	0	0	1	7	0	0	0.00
Nemanja Matić	34	1988-08-01	Midfielder	2441	Serbia	28	1	0	0	0	6	35	8	1	0.04
Paul Pogba	29	1993-03-15	Midfielder	3011	France	35	13	9	7	3	7	41	6	0	0.39
Phil Jones	30	1992-02-21	Defender	1263	England	18	0	1	0	0	4	16	1	0	0.00
Romelu Lukaku	29	1993-05-13	Forward	2130	Belgium	32	12	0	0	0	7	36	4	0	0.51
Scott McTominay	25	1996-12-08	Midfielder	861	England	16	2	0	0	0	3	17	1	0	0.21
Sergio Germán Romero	35	1987-02-22	Goalkeeper	0	Argentina	0	0	0	0	0	0	0	0	0	0.00
Tahith Chong	22	1999-12-04	Forward	36	Netherlands	2	0	0	0	0	0	1	0	0	0.00
Victor Nilsson Lindelöf	28	1994-07-17	Defender	2602	Sweden	30	1	1	0	0	6	38	1	0	0.03

Newcastle United

knitr::include_graphics(path = "./Newcastle_United.png")

NCU <- filter(df, current_club == "Newcastle United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(NCU, format = "html" ,caption = "Stats for Football Team Newcastle United",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Newcastle United
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Antonio Barreca	27	1995-03-18	Defender	4	Italy	1	0	0	0	0	0	0	0	0	0.00
Ayoze Perez	29	1993-07-29	Forward	2929	Spain	37	12	2	0	0	11	34	2	0	0.37
Callum Roberts	25	1997-04-14	Forward	0	England	0	0	0	0	0	0	0	0	0	0.00
Christian Atsu Twasam	30	1992-01-10	Midfielder	1487	Ghana	28	1	0	0	0	8	16	2	0	0.06
Ciaran Clark	33	1989-09-26	Defender	857	Republic of Ireland	11	3	0	0	0	2	14	1	0	0.32
DeAndre Yedlin	29	1993-07-09	Defender	2475	USA	29	1	2	0	0	6	37	7	1	0.04
Fabian Schär	30	1991-12-20	Defender	2002	Switzerland	24	4	1	0	0	8	21	12	0	0.18
Federico Fernández	33	1989-02-21	Defender	1484	Argentina	19	0	1	0	0	4	22	2	0	0.00
Florian Lejeune	31	1991-05-20	Defender	1055	France	12	0	0	0	0	3	12	0	0	0.00
Freddie Woodman	25	1997-03-04	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Isaac Hayden	27	1995-03-22	Midfielder	1886	England	25	1	4	0	0	7	25	4	1	0.05
Jacob Murphy	27	1995-02-24	Midfielder	300	England	9	0	1	0	0	1	7	0	0	0.00
Jamal Lascelles	28	1993-11-11	Defender	2748	England	32	0	1	0	0	11	33	4	0	0.00
Jamie Sterry	26	1995-11-21	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Javier Manquillo Gaitán	28	1994-05-05	Defender	1097	Spain	18	0	3	0	0	6	12	2	0	0.00
Jonjo Shelvey	30	1992-02-27	Midfielder	944	England	16	1	1	0	0	5	11	1	0	0.10
José Luis Sanmartín Mato	32	1990-03-27	Forward	586	Spain	16	2	0	0	0	4	12	1	0	0.31
Karl Darlow	32	1990-10-08	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0	0.00
Kelland Watts	23	1999-11-03	Midfielder	0	England	0	0	0	0	0	0	0	0	0	0.00
Lewis Cass	22	2000-02-27	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Martin Dúbravka	33	1989-01-15	Goalkeeper	3420	Slovakia	38	0	0	0	0	11	44	1	0	0.00
Matt Ritchie	33	1989-09-10	Midfielder	2940	Scotland	36	2	8	1	1	11	37	9	0	0.06
Miguel Ángel Almirón Rejala	28	1994-02-10	Midfielder	763	Paraguay	10	0	0	0	0	3	10	0	0	0.00
Mohamed Diamé	35	1987-06-14	Midfielder	2165	Senegal	29	0	0	0	0	9	28	3	0	0.00
Paul Dummett	31	1991-09-26	Defender	1986	Wales	26	0	0	0	0	9	27	1	0	0.00
Robert Kenedy Nunes do Nascimento	26	1996-02-08	Midfielder	1344	Brazil	25	1	1	0	1	8	17	1	0	0.07
Rondon	33	1989-09-16	Forward	2609	Venezuela	32	11	7	0	0	10	29	1	0	0.38
Sean Longstaff	25	1997-10-30	Midfielder	688	England	9	1	0	0	0	3	8	2	0	0.13
Sung-Yeung Ki	33	1989-01-24	Midfielder	1302	South Korea	18	0	1	0	0	5	18	2	0	0.00
Yoshinori Muto	30	1992-07-15	Forward	516	Japan	17	1	0	0	0	5	10	1	0	0.17

Southampton

knitr::include_graphics(path = "./Southampton.png")

SHN <- filter(df, current_club == "Southampton") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(SHN, format = "html" ,caption = "Stats for Football Team Southampton",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Southampton
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	penalty_misses	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Alex McCarthy	32	1989-12-03	Goalkeeper	2250	England	25	0	0	0	0	4	37	1	0	0.00
Alfie Jones	25	1997-10-07	Defender	0	England	0	0	0	0	0	0	0	0	0	0.00
Angus Gunn	26	1996-01-22	Goalkeeper	1080	England	12	0	0	0	0	3	17	0	0	0.00
Callum Slattery	23	1999-02-08	Midfielder	110	England	3	0	0	0	0	0	0	0	0	0.00
Cedric Soares	31	1991-08-31	Defender	1494	Portugal	18	1	2	0	0	5	26	4	0	0.06
Charlie Austin	33	1989-07-05	Forward	980	England	25	2	2	0	1	6	14	1	0	0.18
Daniel William John Ings	30	1992-07-23	Forward	1668	England	24	7	3	3	0	6	26	1	0	0.38
Fraser Forster	34	1988-03-17	Goalkeeper	90	England	1	0	0	0	0	0	3	0	0	0.00
Jack Stephens	28	1994-01-27	Defender	1697	England	24	1	0	0	0	5	30	4	0	0.05
James Ward-Prowse	27	1994-11-01	Midfielder	1942	England	26	7	0	1	0	4	36	4	0	0.32
Jan Bednarek	26	1996-04-12	Defender	2151	Poland	25	0	1	0	0	3	33	7	0	0.00
Jannik Vestergaard	30	1992-08-03	Defender	2030	Denmark	23	0	0	0	0	4	27	2	0	0.00
Joshua Sims	25	1997-03-28	Midfielder	209	England	7	0	1	0	0	1	5	0	0	0.00
Kayne Ramsey	22	2000-10-10	Midfielder	90	England	1	0	0	0	0	0	3	0	0	0.00
Manolo Gabbiadini	30	1991-11-26	Forward	470	Italy	12	1	0	0	0	3	11	0	0	0.19
Mario Lemina	29	1993-09-01	Midfielder	1615	Gabon	21	1	1	0	0	4	32	5	0	0.06
Matt Targett	27	1995-09-18	Defender	1185	England	16	1	3	0	0	1	24	2	0	0.08
Maya Yoshida	34	1988-08-24	Defender	1520	Japan	17	0	1	0	0	3	27	0	0	0.00
Michael Obafemi	22	2000-07-06	Forward	134	Republic of Ireland	6	1	1	0	0	0	2	1	0	0.67
Mohamed Elyounoussi	28	1994-08-04	Midfielder	790	Norway	16	0	0	0	0	4	8	0	0	0.00
Nathan Redmond	28	1994-03-06	Midfielder	3276	England	38	6	4	0	0	7	53	3	0	0.16
Oriol Romeu	31	1991-09-24	Midfielder	2140	Spain	31	1	0	0	0	6	32	11	0	0.04
Pierre-Emile Højbjerg	27	1995-08-05	Midfielder	2764	Denmark	31	4	3	0	0	4	52	10	2	0.13
Ryan Bertrand	33	1989-08-05	Defender	2160	England	24	1	0	0	0	6	36	8	0	0.04
Sam Gallagher	27	1995-09-15	Forward	30	England	4	0	0	0	0	1	0	0	0	0.00
Shane Long	35	1987-01-22	Forward	1269	Republic of Ireland	26	5	1	0	0	5	20	3	0	0.35
Steven Davis	37	1985-01-01	Midfielder	96	Northern Ireland	3	0	1	0	0	0	3	0	0	0.00
Stuart Armstrong	30	1992-03-30	Midfielder	1432	Scotland	29	3	2	0	0	4	23	2	0	0.19
Tyreke Johnson	24	1998-11-03	Defender	0	England	1	0	0	0	0	0	0	0	0	0.00
Wesley Hoedt	28	1994-03-06	Defender	1170	Netherlands	13	0	0	0	0	4	20	2	0	0.00
Yann Valery	23	1999-02-22	Defender	1715	France	23	2	1	0	0	3	26	5	1	0.10

Tottenham Hotspur

knitr::include_graphics(path = "./Tottenham_Hotspur.png")

THR <- filter(df, current_club == "Tottenham Hotspur") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(THR, format = "html" ,caption = "Stats for Football Team Tottenham Hotspur",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Tottenham Hotspur
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Alfie Whiteman	24	1998-10-02	Goalkeeper	0	England	0	0	0	0	0	0	0	0	0.00
Ben Davies	29	1993-04-24	Defender	1839	Wales	27	0	0	0	10	24	2	0	0.00
Christian Eriksen	30	1992-02-14	Midfielder	2772	Denmark	35	8	12	0	10	34	3	0	0.26
Danny Rose	32	1990-07-02	Defender	1806	England	26	0	3	0	10	12	5	0	0.00
Davinson Sánchez Mina	26	1996-06-12	Defender	1943	Colombia	23	1	1	0	6	21	2	0	0.05
Dele Alli	26	1996-04-11	Midfielder	1827	England	25	5	3	0	7	17	4	0	0.25
Eric Dier	28	1994-01-15	Midfielder	1510	England	20	3	0	0	6	16	4	0	0.18
Erik Lamela	30	1992-03-04	Midfielder	971	Argentina	19	4	2	0	5	11	2	0	0.37
Fernando Llorente Torres	37	1985-02-26	Forward	683	Spain	20	1	4	0	7	8	2	0	0.13
George Marsh	23	1998-11-05	Midfielder	0	England	0	0	0	0	0	0	0	0	0.00
Georges-Kevin N’Koudou Mbida	27	1995-02-13	Forward	4	France	1	0	1	0	0	0	0	0	0.00
Harry Kane	29	1993-07-28	Forward	2427	England	28	17	4	4	10	28	5	0	0.63
Harry Winks	26	1996-02-02	Midfielder	1591	England	26	1	0	0	10	16	4	0	0.06
Heung-Min Son	30	1992-07-08	Forward	2048	South Korea	31	12	6	0	11	20	3	1	0.53
Hugo Lloris	35	1986-12-26	Goalkeeper	2970	France	33	0	0	0	12	30	0	0	0.00
Jan Vertonghen	35	1987-04-24	Defender	1915	Belgium	22	1	0	0	7	21	5	1	0.05
Juan Marcos Foyth	24	1998-01-12	Defender	930	Argentina	12	1	0	0	4	10	4	1	0.10
Kazaiah Sterling	23	1998-11-09	Forward	0	England	0	0	0	0	0	0	0	0	0.00
Kieran Trippier	32	1990-09-19	Defender	2278	England	27	1	3	0	10	20	2	0	0.04
Kyle Walker-Peters	25	1997-04-13	Defender	374	England	6	0	3	0	3	4	1	0	0.00
Lucas Rodrigues Moura da Silva	30	1992-08-13	Midfielder	2127	Brazil	32	10	0	0	12	16	3	0	0.42
Luke Amos	25	1997-02-23	Midfielder	2	England	1	0	0	0	0	0	0	0	0.00
Michel Vorm	39	1983-10-20	Goalkeeper	180	Netherlands	2	0	0	0	0	4	0	0	0.00
Moussa Dembele	35	1987-07-16	Midfielder	516	Belgium	10	0	0	0	3	5	1	0	0.00
Moussa Sissoko	33	1989-08-16	Midfielder	2336	France	29	0	3	0	11	26	2	0	0.00
Oliver Skipp	22	2000-09-16	Midfielder	216	England	8	0	0	0	4	0	0	0	0.00
Paulo Dino Gazzaniga	30	1992-01-02	Goalkeeper	270	Argentina	3	0	0	0	1	1	0	0	0.00
Serge Aurier	29	1992-12-24	Defender	564	Ivory Coast	8	0	2	0	3	9	1	0	0.00
Timothy Eyoma	22	2000-01-29	Defender	0	England	0	0	0	0	0	0	0	0	0.00
Toby Alderweireld	33	1989-03-02	Defender	2924	Belgium	34	0	0	0	12	28	3	0	0.00
Victor Wanyama	31	1991-06-25	Midfielder	509	Kenya	13	1	0	0	6	3	2	0	0.18
Vincent Janssen	28	1994-06-15	Forward	36	Netherlands	3	0	0	0	1	0	0	0	0.00

Watford

knitr::include_graphics(path = "./watford-fc-logo-png-transparent.png")

WFD <- filter(df, current_club == "Watford") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WFD, format = "html" ,caption = "Stats for Football Team Watford",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Watford
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Abdoulaye Doucouré	29	1993-01-01	Midfielder	3062	France	35	5	6	0	5	54	7	0	0.15
Adalberto Peñaranda Maestre	25	1997-05-31	Forward	0	Venezuela	0	0	0	0	0	0	0	0	0.00
Adam Masina	28	1994-01-02	Defender	1003	Italy	14	0	1	0	2	19	5	0	0.00
Adrian Mariappa	36	1986-10-03	Defender	1921	Jamaica	26	0	0	0	6	29	3	0	0.00
Andre Gray	31	1991-06-26	Forward	1358	England	29	7	2	0	5	23	2	0	0.46
Ben Foster	39	1983-04-03	Goalkeeper	3420	England	38	0	0	0	7	57	1	0	0.00
Ben Wilmot	23	1999-11-04	Defender	26	England	2	0	0	0	1	2	0	0	0.00
Christian Kabasele	31	1991-02-24	Defender	1587	Belgium	21	0	0	0	4	25	4	1	0.00
Craig Cathcart	33	1989-02-06	Defender	3099	Northern Ireland	36	3	0	0	6	52	2	0	0.09
Daryl Janmaat	33	1989-07-22	Defender	1521	Netherlands	18	0	2	0	3	22	3	0	0.00
Domingos Quina	22	1999-11-18	Midfielder	335	Portugal	8	1	0	0	1	5	0	0	0.27
Etienne Capoue	34	1988-07-11	Midfielder	2947	France	33	1	3	0	7	47	15	1	0.03
Francisco Femenía Far	31	1991-02-02	Midfielder	2045	Spain	29	1	1	0	5	38	1	0	0.04
Gerard Deulofeu	28	1994-03-13	Forward	2082	Spain	30	10	5	0	6	28	3	0	0.43
Heurelho da Silva Gomes	41	1981-02-15	Goalkeeper	0	Brazil	0	0	0	0	0	0	0	0	0.00
Isaac Ajayi Success	26	1996-01-07	Forward	1037	Nigeria	30	1	1	0	5	20	4	0	0.09
José Holebas	38	1984-06-27	Defender	2394	Greece	28	3	6	0	5	38	13	1	0.11
Ken Sema	29	1993-09-30	Midfielder	755	Sweden	17	1	2	0	6	8	1	0	0.12
Marc Navarro Ceciliano	27	1995-07-02	Defender	84	Spain	2	0	0	0	0	2	0	0	0.00
Miguel Ángel Britos Cabrera	37	1985-07-17	Defender	185	Uruguay	3	0	0	0	1	5	0	0	0.00
Nathaniel Chalobah	27	1994-12-12	Midfielder	266	England	9	0	0	0	1	5	2	0	0.00
Roberto Maximiliano Pereyra	31	1991-01-07	Forward	2825	Argentina	33	6	1	0	5	52	3	0	0.19
Sebastian Prödl	35	1987-06-21	Defender	13	Austria	1	0	0	0	1	0	0	0	0.00
Stefano Okaka	33	1989-08-09	Forward	22	Italy	2	0	0	0	0	1	1	0	0.00
Tom Cleverley	33	1989-08-12	Midfielder	470	England	13	1	0	0	4	7	2	0	0.19
Troy Deeney	34	1988-06-29	Forward	2548	England	32	9	5	1	5	43	5	1	0.32
Will Hughes	27	1995-04-17	Midfielder	2436	England	32	2	4	0	5	39	5	0	0.07

West Ham United

knitr::include_graphics(path = "./West_Ham.png")

WHU <- filter(df, current_club == "West Ham United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WHU, format = "html" ,caption = "Stats for Football Team West Ham United",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team West Ham United
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Aaron Cresswell	32	1989-12-15	Defender	1589	England	20	0	1	0	3	22	1	0	0.00
Adrián San Miguel del Castillo	35	1987-01-03	Goalkeeper	0	Spain	0	0	0	0	0	0	0	0	0.00
Alexandre Nascimento Costa Silva	25	1997-03-16	Forward	17	Portugal	1	0	0	0	0	0	0	0	0.00
Andriy Yarmolenko	33	1989-10-23	Forward	459	Ukraine	9	2	0	0	1	4	2	0	0.39
Andy Carroll	33	1989-01-06	Forward	454	England	12	0	0	0	2	6	2	0	0.00
Angelo Ogbonna	34	1988-05-23	Defender	1870	Italy	24	1	1	0	3	32	2	0	0.05
Arthur Masuaku	28	1993-11-07	Defender	1756	France	23	0	1	0	6	26	2	0	0.00
Benjamin Johnson	22	2000-01-24	Forward	63	England	1	0	0	0	0	1	0	0	0.00
Carlos Sánchez	36	1986-02-06	Midfielder	240	Colombia	7	0	0	0	2	2	0	0	0.00
Conor Coventry	22	2000-03-25	Midfielder	0	Republic of Ireland	0	0	0	0	0	0	0	0	0.00
Declan Rice	23	1999-01-14	Midfielder	3005	Republic of Ireland	34	2	0	0	6	42	4	0	0.06
Fabián Cornelio Balbuena González	31	1991-08-23	Defender	2014	Paraguay	23	1	0	0	5	27	2	0	0.04
Felipe Anderson Pereira Gomes	29	1993-04-15	Midfielder	3054	Brazil	36	9	4	0	6	43	3	0	0.27
Grady Diangana	24	1998-04-19	Midfielder	604	England	17	0	1	0	2	11	0	0	0.00
Issa Diop	25	1997-01-09	Defender	2970	France	33	1	0	0	7	38	4	0	0.03
Jack Wilshere	30	1992-01-01	Midfielder	389	England	8	0	1	0	2	8	2	0	0.00
Javier Hernandez	34	1988-06-01	Forward	1335	Mexico	25	7	1	0	3	16	2	0	0.47
Joe Powell	24	1998-10-30	Forward	0	England	0	0	0	0	0	0	0	0	0.00
Lucas Perez	34	1988-09-10	Forward	468	Spain	15	3	0	0	3	9	0	0	0.58
Manuel Lanzini	29	1993-02-15	Midfielder	688	Argentina	10	1	1	0	2	11	2	0	0.13
Mark Noble	35	1987-05-08	Midfielder	2308	England	31	5	5	4	7	29	7	1	0.19
Marko Arnautović	33	1989-04-19	Forward	2000	Austria	28	10	4	1	5	31	3	0	0.45
Michail Antonio	32	1990-03-28	Midfielder	2099	England	33	6	4	0	5	26	3	0	0.26
Nathan Holland	24	1998-06-19	Midfielder	0	England	0	0	0	0	0	0	0	0	0.00
Pablo Zabaleta	37	1985-01-16	Defender	2092	Argentina	26	0	1	0	4	32	4	0	0.00
Pedro Obiang	30	1992-03-27	Midfielder	1121	Equatorial Guinea	24	0	1	0	7	17	0	0	0.00
Robert Snodgrass	35	1987-09-07	Midfielder	2222	Scotland	33	2	5	0	6	31	10	0	0.08
Ryan Fredericks	30	1992-10-10	Midfielder	1085	England	15	1	0	0	3	13	5	0	0.08
Samir Nasri	35	1987-06-26	Midfielder	246	France	5	0	2	0	1	2	0	0	0.00
Łukasz Fabiański	37	1985-04-18	Goalkeeper	3420	Poland	38	0	0	0	7	48	0	0	0.00

Wolverhampton Wanderers

knitr::include_graphics(path = "./Wolverhampton.png")

WHW <- filter(df, current_club == "Wolverhampton Wanderers") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WHW, format = "html" ,caption = "Stats for Football Team Wolverhampton Wanderers",align = "cccccccccccccccc") %>% kable_styling()

Stats for Football Team Wolverhampton Wanderers
full_name	age	birthday_gmt	position	minutes_played_overall	nationality	appearances_overall	goals_overall	assists_overall	penalty_goals	clean_sheets_overall	conceded_overall	yellow_cards_overall	red_cards_overall	goals_per_90_overall
Adama Traoré Diarra	26	1996-01-25	Midfielder	890	Spain	29	1	1	0	6	11	1	0	0.10
Bright Enobakhare	24	1998-02-08	Forward	0	England	0	0	0	0	0	0	0	0	0.00
Cameron John	23	1999-08-24	Defender	0	England	0	0	0	0	0	0	0	0	0.00
Conor Coady	29	1993-02-25	Midfielder	3420	England	38	0	0	0	9	43	5	0	0.00
Diogo José Teixeira da Silva	25	1996-12-04	Midfielder	2371	Portugal	33	9	5	0	9	29	11	0	0.34
Hélder Wander Sousa Azevedo Costa	28	1994-01-12	Midfielder	1345	Portugal	25	1	2	0	5	18	3	0	0.07
Ivan Ricardo Neves Abreu Cavaleiro	29	1993-10-18	Forward	683	Portugal	23	3	1	0	5	10	1	0	0.40
João Moutinho	36	1986-09-08	Midfielder	3040	Portugal	38	1	8	0	9	37	4	0	0.03
John Ruddy	36	1986-10-24	Goalkeeper	90	England	1	0	0	0	1	0	0	0	0.00
Jonny	28	1994-03-03	Defender	2780	Spain	33	1	1	0	8	36	6	0	0.03
Kortney Hause	27	1995-07-16	Defender	0	England	0	0	0	0	0	0	0	0	0.00
Leander Dendoncker	27	1995-04-15	Midfielder	1469	Belgium	19	2	0	0	4	19	1	0	0.12
Leonardo Bonatini Lohner Maia	28	1994-03-28	Forward	128	Brazil	7	0	1	0	3	0	0	0	0.00
Matt Doherty	30	1992-01-16	Defender	3147	Republic of Ireland	38	4	5	0	9	38	5	0	0.11
Max Kilman	25	1997-05-23	Defender	0	England	1	0	0	0	1	0	0	0	0.00
Morgan Gibbs-White	22	2000-01-27	Midfielder	647	England	26	0	1	0	5	9	1	0	0.00
Raúl Alonso Jiménez Rodríguez	31	1991-05-05	Forward	3124	Mexico	38	13	7	2	9	39	4	0	0.37
Romain Saïss	32	1990-03-26	Midfielder	1144	Morocco	19	2	0	0	4	16	7	0	0.16
Rúben Diogo Da Silva Neves	25	1997-03-13	Midfielder	3009	Portugal	35	4	3	2	8	40	8	0	0.12
Rúben Gonçalo Silva Nascimento Vinagre	23	1999-04-09	Defender	703	Portugal	17	0	0	0	5	9	1	0	0.00
Rui Pedro dos Santos Patrício	34	1988-02-15	Goalkeeper	3330	Portugal	37	0	0	0	8	43	0	0	0.00
Ryan Bennett	32	1990-03-06	Defender	3060	England	34	1	0	0	9	36	12	0	0.03
Ryan Giles	22	2000-01-26	Midfielder	0	England	0	0	0	0	0	0	0	0	0.00
Will Norris	29	1993-08-12	Goalkeeper	0	England	1	0	0	0	1	0	0	0	0.00
Willy Boly	31	1991-02-03	Defender	3169	France	36	4	0	0	8	38	3	1	0.11

Best Forward

A forward is praised by their ability to show up, get goals, and work with those around them to get goals.

Forward <- filter(df, rank_in_league_top_attackers != -1) %>% 
  select(c('full_name','goals_overall','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_attackers', 'appearances_overall' )) 

ForwardClean <- Forward[order(Forward$rank_in_league_top_attackers),]

kable(ForwardClean, format = "html" , caption = "Top league Forwards",align = "cccccccccccccccc") %>% kable_styling()

Top league Forwards
full_name	goals_overall	assists_overall	position	current_club	age	birthday_gmt	rank_in_league_top_attackers	appearances_overall
Sergio Aguero	21	8	Forward	Manchester City	34	1988-06-02	1	33
Divock Origi	3	1	Forward	Liverpool	27	1995-04-18	2	12
Pierre-Emerick Aubameyang	22	5	Forward	Arsenal	33	1989-06-18	3	36
Sadio Mané	22	1	Forward	Liverpool	30	1992-04-10	4	36
Harry Kane	17	4	Forward	Tottenham Hotspur	29	1993-07-28	5	28
Gabriel Jesus	7	3	Forward	Manchester City	25	1997-04-03	6	29
Mohamed Salah	22	8	Forward	Liverpool	30	1992-06-15	7	38
Michy Batshuayi	5	0	Forward	Crystal Palace	29	1993-10-02	8	11
Jamie Vardy	18	4	Forward	Leicester City	35	1987-01-11	9	34
Lucas Perez	3	0	Forward	West Ham United	34	1988-09-10	10	15
Ruben Loftus-Cheek	6	2	Midfielder	Chelsea	26	1996-01-23	11	24
Raheem Sterling	17	10	Forward	Manchester City	27	1994-12-08	12	34
Anthony Martial	10	2	Forward	Manchester United	26	1995-12-05	13	27
Heung-Min Son	12	6	Forward	Tottenham Hotspur	30	1992-07-08	14	31
Xherdan Shaqiri	6	3	Midfielder	Liverpool	31	1991-10-10	15	24
Romelu Lukaku	12	0	Forward	Manchester United	29	1993-05-13	16	32
Callum Wilson	14	9	Forward	AFC Bournemouth	30	1992-02-27	17	30
Eden Hazard	16	15	Midfielder	Chelsea	31	1991-01-07	18	37
Leroy Sané	10	10	Midfielder	Manchester City	26	1996-01-11	19	31
Alvaro Morata	5	0	Forward	Chelsea	30	1992-10-23	20	16
Alexandre Lacazette	13	8	Forward	Arsenal	31	1991-05-28	21	35
Riyad Mahrez	7	4	Midfielder	Manchester City	31	1991-02-21	22	27
Javier Hernandez	7	1	Forward	West Ham United	34	1988-06-01	23	25
Glenn Murray	13	1	Forward	Brighton & Hove Albion	39	1983-09-25	24	38
Andre Gray	7	2	Forward	Watford	31	1991-06-26	25	29
Marko Arnautović	10	4	Forward	West Ham United	33	1989-04-19	26	28
Ashley Barnes	12	2	Forward	Burnley	32	1989-10-30	27	37
Richarlison de Andrade	13	1	Forward	Everton	25	1997-05-10	28	35
Gerard Deulofeu	10	5	Forward	Watford	28	1994-03-13	29	30
Lucas Rodrigues Moura da Silva	10	0	Midfielder	Tottenham Hotspur	30	1992-08-13	30	32
Karlan Ahearne-Grant	4	0	Forward	Huddersfield Town	24	1997-12-19	31	13
Roberto Firmino	12	6	Forward	Liverpool	31	1991-10-02	32	34
Gonzalo Higuain	5	0	Forward	Chelsea	34	1987-12-10	33	14
Ivan Ricardo Neves Abreu Cavaleiro	3	1	Forward	Wolverhampton Wanderers	29	1993-10-18	34	23
Pedro Rodriguez	8	2	Midfielder	Chelsea	35	1987-07-28	35	31
Andriy Yarmolenko	2	0	Forward	West Ham United	33	1989-10-23	36	9
Paul Pogba	13	9	Midfielder	Manchester United	29	1993-03-15	37	35
Aboubakar Kamara	3	0	Forward	Fulham	27	1995-03-07	38	13
Daniel William John Ings	7	3	Forward	Southampton	30	1992-07-23	39	24
Rondon	11	7	Forward	Newcastle United	33	1989-09-16	40	32
Marcus Rashford	10	6	Forward	Manchester United	25	1997-10-31	41	33
Raúl Alonso Jiménez Rodríguez	13	7	Forward	Wolverhampton Wanderers	31	1991-05-05	42	38
Gylfi Sigurdsson	13	6	Midfielder	Everton	33	1989-09-08	43	38
Ayoze Perez	12	2	Forward	Newcastle United	29	1993-07-29	44	37
Erik Lamela	4	2	Midfielder	Tottenham Hotspur	30	1992-03-04	45	19
Nathaniel Mendez-Laing	4	1	Midfielder	Cardiff City	30	1992-04-15	46	20
Ryan Guno Babel	5	3	Forward	Fulham	35	1986-12-19	47	16
Daniel Sturridge	2	1	Forward	Liverpool	33	1989-09-01	48	18
Joshua King	12	3	Forward	AFC Bournemouth	30	1992-01-15	49	35
Chris Wood	10	2	Forward	Burnley	30	1991-12-07	50	38
Shane Long	5	1	Forward	Southampton	35	1987-01-22	51	26
Diogo José Teixeira da Silva	9	5	Midfielder	Wolverhampton Wanderers	25	1996-12-04	52	33
Henrikh Mkhitaryan	6	4	Midfielder	Arsenal	33	1989-01-21	53	25
André Schürrle	6	0	Midfielder	Fulham	31	1990-11-06	54	24
Bobby Reid	5	2	Midfielder	Cardiff City	29	1993-02-02	55	27
Ciaran Clark	3	0	Defender	Newcastle United	33	1989-09-26	56	11
Troy Deeney	9	5	Forward	Watford	34	1988-06-29	57	32
James Ward-Prowse	7	0	Midfielder	Southampton	27	1994-11-01	58	26
Luka Milivojević	12	2	Midfielder	Crystal Palace	31	1991-04-07	59	38
Florin Andone	3	0	Forward	Brighton & Hove Albion	29	1993-04-11	60	23
José Luis Sanmartín Mato	2	0	Forward	Newcastle United	32	1990-03-27	61	16
Aleksandar Mitrović	11	3	Forward	Fulham	28	1994-09-16	62	37
Wilfried Zaha	10	5	Midfielder	Crystal Palace	29	1992-11-10	63	34
Sam Vokes	3	0	Forward	Burnley	33	1989-10-21	64	20
Dominic Calvert-Lewin	6	2	Forward	Everton	25	1997-03-16	65	35
Matěj Vydra	1	1	Forward	Burnley	30	1992-05-01	66	13
Philip Foden	1	0	Midfielder	Manchester City	22	2000-05-28	67	13
David Brooks	7	5	Forward	AFC Bournemouth	25	1997-07-08	68	30
Aaron Ramsey	4	6	Midfielder	Arsenal	31	1990-12-26	69	28
Felipe Anderson Pereira Gomes	9	4	Midfielder	West Ham United	29	1993-04-15	70	36
Phil Jagielka	1	0	Defender	Everton	40	1982-08-17	71	7
Domingos Quina	1	0	Midfielder	Watford	22	1999-11-18	72	8
Mesut Özil	5	2	Midfielder	Arsenal	34	1988-10-15	73	24
Cenk Tosun	3	3	Forward	Everton	31	1991-06-07	74	25
Lys Mousset	1	0	Forward	AFC Bournemouth	26	1996-02-08	75	24
Christian Eriksen	8	12	Midfielder	Tottenham Hotspur	30	1992-02-14	76	35
Michail Antonio	6	4	Midfielder	West Ham United	32	1990-03-28	77	33
İlkay Gündoğan	6	3	Midfielder	Manchester City	32	1990-10-24	78	31
Kadeem Harris	1	0	Midfielder	Cardiff City	29	1993-06-08	79	13
Youri Tielemans	3	4	Midfielder	Leicester City	25	1997-05-07	80	13
James Milner	5	4	Midfielder	Liverpool	36	1986-01-04	81	31
Dele Alli	5	3	Midfielder	Tottenham Hotspur	26	1996-04-11	82	25
James Maddison	7	7	Midfielder	Leicester City	25	1996-11-23	83	36
Ross Barkley	3	5	Midfielder	Chelsea	28	1993-12-05	84	27
Bernardo Silva	7	7	Midfielder	Manchester City	28	1994-08-10	85	36
Olivier Giroud	2	4	Forward	Chelsea	36	1986-09-30	86	27
Jesse Lingard	4	2	Midfielder	Manchester United	29	1992-12-15	87	27
David Silva	6	8	Midfielder	Manchester City	36	1986-01-08	88	33
Jeffrey Schlupp	4	1	Defender	Crystal Palace	29	1992-12-23	89	30
Theo Walcott	5	2	Forward	Everton	33	1989-03-16	90	37
Scott McTominay	2	0	Midfielder	Manchester United	25	1996-12-08	91	16
Juan Mata	3	2	Midfielder	Manchester United	34	1988-04-28	92	22
Laurent Koscielny	3	0	Defender	Arsenal	37	1985-09-10	93	17
Danny Ward	1	0	Forward	Cardiff City	31	1990-12-09	94	14
Ryan Fraser	7	14	Midfielder	AFC Bournemouth	28	1994-02-24	95	38
Mark Noble	5	5	Midfielder	West Ham United	35	1987-05-08	96	31
Roberto Maximiliano Pereyra	6	1	Forward	Watford	31	1991-01-07	97	33
Stuart Armstrong	3	2	Midfielder	Southampton	30	1992-03-30	98	29
Tom Cleverley	1	0	Midfielder	Watford	33	1989-08-12	99	13
Manolo Gabbiadini	1	0	Forward	Southampton	30	1991-11-26	100	12
Floyd Ayité	1	0	Midfielder	Fulham	33	1988-12-15	101	16
Andros Townsend	6	4	Midfielder	Crystal Palace	31	1991-07-16	102	38
Demarai Gray	4	1	Midfielder	Leicester City	26	1996-06-28	103	34
Junior Stanislas	2	3	Midfielder	AFC Bournemouth	32	1989-11-26	104	23
Charlie Austin	2	2	Forward	Southampton	33	1989-07-05	105	25
Victor Wanyama	1	0	Midfielder	Tottenham Hotspur	31	1991-06-25	106	13
Eric Dier	3	0	Midfielder	Tottenham Hotspur	28	1994-01-15	107	20
Callum Paterson	4	1	Defender	Cardiff City	28	1994-10-13	108	27
Kevin De Bruyne	2	2	Midfielder	Manchester City	31	1991-06-28	109	19
Fabian Schär	4	1	Defender	Newcastle United	30	1991-12-20	110	24
Víctor Camarasa	5	4	Midfielder	Cardiff City	28	1994-05-28	111	32
Dwight McNeil	3	5	Forward	Burnley	22	1999-11-22	112	21
Yoshinori Muto	1	0	Forward	Newcastle United	30	1992-07-15	113	17
Joel Ward	1	0	Defender	Crystal Palace	32	1989-10-29	114	7
Romain Saïss	2	0	Midfielder	Wolverhampton Wanderers	32	1990-03-26	115	19
Nathan Redmond	6	4	Midfielder	Southampton	28	1994-03-06	116	38
Andreas Pereira	1	1	Midfielder	Manchester United	26	1996-01-01	117	15
Souleymane Bamba	4	1	Defender	Cardiff City	37	1985-01-13	118	28
Josh Murphy	3	2	Forward	Cardiff City	27	1995-02-24	119	29
Jürgen Locadia	2	0	Forward	Brighton & Hove Albion	28	1993-11-07	120	26
Leon Balogun	1	0	Defender	Brighton & Hove Albion	34	1988-06-28	121	8
Johann Berg Guðmundsson	3	6	Midfielder	Burnley	32	1990-10-27	122	29
Shane Duffy	5	1	Defender	Brighton & Hove Albion	30	1992-01-01	123	35
Abdoulaye Doucouré	5	6	Midfielder	Watford	29	1993-01-01	124	35
Wes Morgan	3	0	Defender	Leicester City	38	1984-01-21	125	22
Pascal Groß	3	3	Midfielder	Brighton & Hove Albion	31	1991-06-15	126	25
Granit Xhaka	4	2	Midfielder	Arsenal	30	1992-09-27	127	29
Alex Iwobi	3	6	Forward	Arsenal	26	1996-05-03	128	35
Mathias Jattah-Njie Jørgensen	3	1	Defender	Huddersfield Town	32	1990-04-23	129	24
Manuel Lanzini	1	1	Midfielder	West Ham United	29	1993-02-15	130	10
Jeff Hendrick	3	0	Midfielder	Burnley	30	1992-01-31	131	32
Willian	3	6	Forward	Chelsea	34	1988-08-09	132	32
Fernando Llorente Torres	1	4	Forward	Tottenham Hotspur	37	1985-02-26	133	20
Ander Herrera	2	3	Midfielder	Manchester United	33	1989-08-14	134	22
Sean Longstaff	1	0	Midfielder	Newcastle United	25	1997-10-30	135	9
Pierre-Emile Højbjerg	4	3	Midfielder	Southampton	27	1995-08-05	136	31
David Junior Hoilett	3	1	Forward	Cardiff City	32	1990-06-05	137	32
Naby Deco Keïta	2	1	Midfielder	Liverpool	27	1995-02-10	138	25
Jon Gorenc Stankovič	1	0	Defender	Huddersfield Town	26	1996-01-14	139	11
Rachid Ghezzal	1	0	Forward	Leicester City	30	1992-05-09	140	19
N’Golo Kanté	4	4	Midfielder	Chelsea	31	1991-03-29	141	36
Kenneth Dahrup Zohorè	1	1	Forward	Cardiff City	28	1994-01-31	142	19
Ken Sema	1	2	Midfielder	Watford	29	1993-09-30	143	17
Aaron Mooy	3	1	Midfielder	Huddersfield Town	32	1990-09-15	144	29
Rúben Diogo Da Silva Neves	4	3	Midfielder	Wolverhampton Wanderers	25	1997-03-13	145	35
Leander Dendoncker	2	0	Midfielder	Wolverhampton Wanderers	27	1995-04-15	146	19
Lucas Digne	4	4	Defender	Everton	29	1993-07-20	147	35
Willy Boly	4	0	Defender	Wolverhampton Wanderers	31	1991-02-03	148	36
Christian Benteke	1	1	Forward	Crystal Palace	31	1990-12-03	149	16
Nathan Aké	4	0	Defender	AFC Bournemouth	27	1995-02-18	150	38
Danilo	1	0	Defender	Manchester City	31	1991-07-15	151	11
Virgil van Dijk	4	2	Defender	Liverpool	31	1991-07-08	152	38
José Holebas	3	6	Defender	Watford	38	1984-06-27	153	28
Jordon Ibe	1	1	Midfielder	AFC Bournemouth	26	1995-12-08	154	19
Matt Doherty	4	5	Defender	Wolverhampton Wanderers	30	1992-01-16	155	38
Marc Albrighton	2	2	Midfielder	Leicester City	32	1989-11-18	156	27
Juan Marcos Foyth	1	0	Defender	Tottenham Hotspur	24	1998-01-12	157	12
Dan Gosling	2	1	Midfielder	AFC Bournemouth	32	1990-02-01	158	25
Anthony Knockaert	2	6	Midfielder	Brighton & Hove Albion	30	1991-11-20	159	30
Adama Traoré Diarra	1	1	Midfielder	Wolverhampton Wanderers	26	1996-01-25	160	29
Yerry Fernando Mina González	1	0	Defender	Everton	28	1994-09-23	161	13
Yann Valery	2	1	Defender	Southampton	23	1999-02-22	162	23
Beram Kayal	1	1	Midfielder	Brighton & Hove Albion	34	1988-05-02	163	18
Georginio Wijnaldum	3	0	Midfielder	Liverpool	31	1990-11-11	164	35
Harry Maguire	3	0	Defender	Leicester City	29	1993-03-05	165	31
Alexis Sanchez	1	3	Forward	Manchester United	33	1988-12-19	166	20
Jonjo Shelvey	1	1	Midfielder	Newcastle United	30	1992-02-27	167	16
Steve Mounié	2	3	Forward	Huddersfield Town	28	1994-09-29	168	31
Kelechi Iheanacho	1	3	Forward	Leicester City	26	1996-10-03	169	30
James Tarkowski	3	1	Defender	Burnley	29	1992-11-19	170	35
Alex Pritchard	2	0	Midfielder	Huddersfield Town	29	1993-05-03	171	30
Isaac Mbenza	1	1	Forward	Huddersfield Town	26	1996-03-08	172	22
Dejan Lovren	1	0	Defender	Liverpool	33	1989-07-05	173	13
Ainsley Maitland-Niles	1	1	Midfielder	Arsenal	25	1997-08-29	174	16
Harvey Lewis Barnes	1	2	Midfielder	Leicester City	24	1997-12-09	175	16
Aymeric Laporte	3	3	Defender	Manchester City	28	1994-05-27	176	35
Craig Cathcart	3	0	Defender	Watford	33	1989-02-06	177	36
Frederico Rodrigues Santos	1	1	Midfielder	Manchester United	29	1993-03-05	178	17
James McArthur	3	6	Midfielder	Crystal Palace	35	1987-10-07	179	38
Luciano Vietto	1	4	Forward	Fulham	28	1993-12-05	180	20
Isaac Ajayi Success	1	1	Forward	Watford	26	1996-01-07	181	30
Ryan Sessegnon	2	6	Defender	Fulham	22	2000-05-18	182	35
Matt Targett	1	3	Defender	Southampton	27	1995-09-18	183	16
Patrick van Aanholt	3	2	Defender	Crystal Palace	32	1990-08-29	184	36
Philip Billing	2	0	Midfielder	Huddersfield Town	26	1996-06-11	185	27
David Luiz	3	2	Defender	Chelsea	35	1987-04-22	186	36
Jordan Ayew	1	2	Forward	Crystal Palace	31	1991-09-11	187	20
Robert Snodgrass	2	5	Midfielder	West Ham United	35	1987-09-07	188	33
Ryan Fredericks	1	0	Midfielder	West Ham United	30	1992-10-10	189	15
Lucas Torreira	2	2	Midfielder	Arsenal	26	1996-02-11	190	34
Marcos Alonso	2	4	Defender	Chelsea	31	1990-12-28	191	31
Kurt Zouma	2	2	Defender	Everton	28	1994-10-27	192	32
Robert Kenedy Nunes do Nascimento	1	1	Midfielder	Newcastle United	26	1996-02-08	193	25
Vincent Kompany	1	0	Defender	Manchester City	36	1986-04-10	194	17
Ashley Young	2	2	Midfielder	Manchester United	37	1985-07-09	195	30
Aaron Lennon	1	1	Midfielder	Burnley	35	1987-04-16	196	16
Séamus Coleman	2	2	Defender	Everton	34	1988-10-11	197	29
Calum Chambers	2	0	Defender	Fulham	27	1995-01-20	198	31
Will Hughes	2	4	Midfielder	Watford	27	1995-04-17	199	32
Hélder Wander Sousa Azevedo Costa	1	2	Midfielder	Wolverhampton Wanderers	28	1994-01-12	200	25
Shkodran Mustafi	2	0	Defender	Arsenal	30	1992-04-17	201	31
Jefferson Lerma	2	0	Midfielder	AFC Bournemouth	28	1994-10-25	202	30
Lewis Dunk	2	1	Defender	Brighton & Hove Albion	30	1991-11-21	203	36
Cedric Soares	1	2	Defender	Southampton	31	1991-08-31	204	18
Juninho Bacuna	1	0	Midfielder	Huddersfield Town	25	1997-08-07	205	21
Christian Atsu Twasam	1	0	Midfielder	Newcastle United	30	1992-01-10	206	28
Harry Winks	1	0	Midfielder	Tottenham Hotspur	26	1996-02-02	207	26
Charlie Daniels	1	0	Defender	AFC Bournemouth	36	1986-09-07	208	21
Max Meyer	1	2	Midfielder	Crystal Palace	27	1995-09-18	209	29
Declan Rice	2	0	Midfielder	West Ham United	23	1999-01-14	210	34
Mario Lemina	1	1	Midfielder	Southampton	29	1993-09-01	211	21
Ashley Westwood	2	7	Midfielder	Burnley	32	1990-04-01	212	34
Jorginho	2	0	Midfielder	Chelsea	30	1991-12-20	213	37
Ricardo Domingos Barbosa Pereira	2	6	Defender	Leicester City	29	1993-10-06	214	35
Joel Matip	1	0	Defender	Liverpool	31	1991-08-08	215	22
Matt Ritchie	2	8	Midfielder	Newcastle United	33	1989-09-10	216	36
Jordan Henderson	1	3	Midfielder	Liverpool	32	1990-06-17	217	32
Onyinye Wilfred Ndidi	2	0	Midfielder	Leicester City	25	1996-12-16	218	38
Isaac Hayden	1	4	Midfielder	Newcastle United	27	1995-03-22	219	25
André Filipe Tavares Gomes	1	1	Midfielder	Everton	29	1993-07-30	220	27
Davinson Sánchez Mina	1	1	Defender	Tottenham Hotspur	26	1996-06-12	221	23
Nacho Monreal	1	3	Defender	Arsenal	36	1986-02-26	222	22
Jack Stephens	1	0	Defender	Southampton	28	1994-01-27	223	24
Jonny Evans	1	0	Defender	Leicester City	34	1988-01-03	224	24
Jan Vertonghen	1	0	Defender	Tottenham Hotspur	35	1987-04-24	225	22
Angelo Ogbonna	1	1	Defender	West Ham United	34	1988-05-23	226	24
Adam Smith	1	1	Defender	AFC Bournemouth	31	1991-04-29	227	25
Fernando Luiz Rosa	1	3	Midfielder	Manchester City	37	1985-05-04	228	29
Fabinho	1	2	Midfielder	Liverpool	29	1993-10-23	229	28
Kieran Trippier	1	3	Defender	Tottenham Hotspur	32	1990-09-19	230	27
Fabián Cornelio Balbuena González	1	0	Defender	West Ham United	31	1991-08-23	231	23
Aron Einar Gunnarsson	1	1	Midfielder	Cardiff City	33	1989-04-22	232	28
Trent Alexander-Arnold	1	12	Defender	Liverpool	24	1998-10-07	233	29
Sokratis Papastathopoulos	1	2	Defender	Arsenal	34	1988-06-09	234	25
James Tomkins	1	1	Defender	Crystal Palace	33	1989-03-29	235	29
Jean Michau00ebl Seri	1	2	Midfielder	Fulham	31	1991-07-19	236	32
DeAndre Yedlin	1	2	Defender	Newcastle United	29	1993-07-09	237	29
Tom Cairney	1	1	Midfielder	Fulham	31	1991-01-20	238	31
Nemanja Matić	1	0	Midfielder	Manchester United	34	1988-08-01	239	28
Francisco Femenía Far	1	1	Midfielder	Watford	31	1991-02-02	240	29
Davy Pröpper	1	1	Midfielder	Brighton & Hove Albion	31	1991-09-02	241	30
Solomon March	1	5	Midfielder	Brighton & Hove Albion	28	1994-07-20	242	35
Bernard Anício Caldeira Duarte	1	3	Midfielder	Everton	30	1992-09-08	243	34
Oriol Romeu	1	0	Midfielder	Southampton	31	1991-09-24	244	31
Ryan Bertrand	1	0	Defender	Southampton	33	1989-08-05	245	24
Chris Smalling	1	0	Defender	Manchester United	32	1989-11-22	246	24
Dale Stephens	1	1	Midfielder	Brighton & Hove Albion	33	1989-06-12	247	30
Issa Diop	1	0	Defender	West Ham United	25	1997-01-09	248	33
Jack Cork	1	2	Midfielder	Burnley	33	1989-06-25	249	37
Kyle Walker	1	1	Defender	Manchester City	32	1990-05-28	250	33
Michael Keane	1	2	Defender	Everton	29	1993-01-11	251	33
Christopher Schindler	1	0	Defender	Huddersfield Town	32	1990-04-29	252	37
Etienne Capoue	1	3	Midfielder	Watford	34	1988-07-11	253	33
Steve Cook	1	1	Defender	AFC Bournemouth	31	1991-04-19	254	31
Sean Morrison	1	3	Defender	Cardiff City	31	1991-01-08	255	34
Ryan Bennett	1	0	Defender	Wolverhampton Wanderers	32	1990-03-06	256	34
Jonny	1	1	Defender	Wolverhampton Wanderers	28	1994-03-03	257	33
João Moutinho	1	8	Midfielder	Wolverhampton Wanderers	36	1986-09-08	258	38
Antonio Rüdiger	1	0	Defender	Chelsea	29	1993-03-03	259	33
Cesar Azpilicueta	1	5	Defender	Chelsea	33	1989-08-28	260	38
Terence Kongolo	1	1	Defender	Huddersfield Town	28	1994-02-14	261	32
Luke Shaw	1	4	Defender	Manchester United	27	1995-07-12	262	29
Victor Nilsson Lindelöf	1	1	Defender	Manchester United	28	1994-07-17	263	30
Steven Defour	0	0	Midfielder	Burnley	34	1988-04-15	264	6
Tim Ream	0	0	Defender	Fulham	35	1987-10-05	265	26
Jose Izquierdo	0	1	Forward	Brighton & Hove Albion	30	1992-07-07	266	15
Caglar Söyüncü	0	0	Defender	Leicester City	26	1996-05-23	267	6
Robbie Brady	0	1	Midfielder	Burnley	30	1992-01-14	268	16
Danny Simpson	0	0	Defender	Leicester City	35	1987-01-04	269	6
Andy Carroll	0	0	Forward	West Ham United	33	1989-01-06	270	12
Nampalys Mendy	0	0	Midfielder	Leicester City	30	1992-06-23	271	31
Jack Simpson	0	0	Defender	AFC Bournemouth	25	1996-12-18	272	6
Nicolas Otamendi	0	0	Defender	Manchester City	34	1988-02-12	273	18
Emerson Palmieri dos Santos	0	0	Defender	Chelsea	28	1994-08-03	274	10
Hamza Choudhury	0	0	Midfielder	Leicester City	25	1997-10-01	275	9
Scott Dann	0	1	Defender	Crystal Palace	35	1987-02-14	276	10
Callum Hudson-Odoi	0	1	Midfielder	Chelsea	21	2000-11-07	277	10
Florian Lejeune	0	0	Defender	Newcastle United	31	1991-05-20	278	12
Chris Mepham	0	1	Defender	AFC Bournemouth	24	1997-11-05	279	13
Dominic Solanke	0	1	Forward	AFC Bournemouth	25	1997-09-14	280	10
Leandro Bacuna	0	0	Midfielder	Cardiff City	31	1991-08-21	281	11
Miguel Ángel Almirón Rejala	0	0	Midfielder	Newcastle United	28	1994-02-10	282	10
José Diogo Dalot Teixeira	0	2	Defender	Manchester United	23	1999-03-18	283	16
Oleksandr Zinchenko	0	3	Midfielder	Manchester City	25	1996-12-15	284	14
Sead Kolašinac	0	5	Defender	Arsenal	29	1993-06-20	285	24
Denis Odoi	0	1	Defender	Fulham	34	1988-05-27	286	31
Danny Rose	0	3	Defender	Tottenham Hotspur	32	1990-07-02	287	26
André-Frank Zambo Anguissa	0	0	Midfielder	Fulham	26	1995-11-16	288	22
Jonjoe Kenny	0	1	Defender	Everton	25	1997-03-15	289	10
Aaron Cresswell	0	1	Defender	West Ham United	32	1989-12-15	290	20
Mateo Kovačić	0	2	Midfielder	Chelsea	28	1994-05-06	291	32
Ademola Lookman	0	2	Forward	Everton	25	1997-10-20	292	21
Kevin Long	0	1	Defender	Burnley	32	1990-08-18	293	6
Martín Montoya	0	1	Defender	Brighton & Hove Albion	31	1991-04-14	294	25
Fabian Delph	0	1	Midfielder	Manchester City	32	1989-11-21	295	11
Marcus Bettinelli	0	0	Goalkeeper	Fulham	30	1992-05-24	296	7
Federico Fernández	0	1	Defender	Newcastle United	33	1989-02-21	297	19
Grady Diangana	0	1	Midfielder	West Ham United	24	1998-04-19	298	17
Phil Jones	0	1	Defender	Manchester United	30	1992-02-21	299	18
Antonio Valencia	0	0	Defender	Manchester United	37	1985-08-04	300	6
Jacob Murphy	0	1	Midfielder	Newcastle United	27	1995-02-24	301	9
Jason Puncheon	0	0	Midfielder	Huddersfield Town	36	1986-06-26	302	11
Elias Kachunga	0	0	Forward	Huddersfield Town	30	1992-04-22	303	20
Harry Arter	0	1	Midfielder	Cardiff City	32	1989-12-28	304	25
Erik Durm	0	1	Defender	Huddersfield Town	30	1992-05-12	305	28
Diego Rico	0	0	Defender	AFC Bournemouth	29	1993-02-23	306	12
Alfie Mawson	0	0	Defender	Fulham	28	1994-01-19	307	15
Maya Yoshida	0	1	Defender	Southampton	34	1988-08-24	308	17
John Stones	0	0	Defender	Manchester City	28	1994-05-28	309	24
David de Gea	0	0	Goalkeeper	Manchester United	31	1990-11-07	310	38
Benjamin Mendy	0	5	Defender	Manchester City	28	1994-07-17	311	10
Aaron Wan-Bissaka	0	3	Midfielder	Crystal Palace	24	1997-11-26	312	35
Greg Cunningham	0	0	Defender	Cardiff City	31	1991-01-31	313	7
Maxime Le Marchand	0	1	Defender	Fulham	33	1989-10-11	314	26
Cyrus Christie	0	1	Defender	Fulham	30	1992-09-30	315	28
Joe Bryan	0	1	Defender	Fulham	29	1993-09-17	316	28
Kevin McDonald	0	0	Midfielder	Fulham	33	1988-11-04	317	15
Stefan Marius Johansen	0	0	Midfielder	Fulham	31	1991-01-08	318	12
Timothy Fosu-Mensah	0	0	Defender	Fulham	24	1998-01-02	319	12
Sergio Rico	0	0	Goalkeeper	Fulham	29	1993-09-01	320	29
Wayne Hennessey	0	0	Goalkeeper	Crystal Palace	35	1987-01-24	321	18
Mamadou Sakho	0	0	Defender	Crystal Palace	32	1990-02-13	322	27
Cheikhou Kouyaté	0	2	Midfielder	Crystal Palace	32	1989-12-21	323	31
Joe Bennett	0	1	Defender	Cardiff City	32	1990-03-28	324	30
Vicente Guaita	0	0	Goalkeeper	Crystal Palace	35	1987-01-10	325	20
Martin Kelly	0	0	Defender	Crystal Palace	32	1990-04-27	326	13
Ben Hamer	0	0	Goalkeeper	Huddersfield Town	34	1987-11-20	327	7
Chris Löwe	0	2	Defender	Huddersfield Town	33	1989-04-16	328	29
Florent Hadergjonaj	0	0	Defender	Huddersfield Town	28	1994-07-31	329	24
Jonathan Hogg	0	1	Midfielder	Huddersfield Town	33	1988-12-06	330	29
Laurent Depoitre	0	1	Forward	Huddersfield Town	33	1988-12-07	331	23
Adama Diakhaby	0	0	Forward	Huddersfield Town	26	1996-07-05	332	12
Jonas Lössl	0	1	Goalkeeper	Huddersfield Town	33	1989-02-01	333	31
Tom Smith	0	0	Defender	Huddersfield Town	30	1992-04-14	334	15
Rajiv van La Parra	0	0	Midfielder	Huddersfield Town	31	1991-06-04	335	5
Joe Ralls	0	0	Midfielder	Cardiff City	29	1993-10-13	336	28
Bruno Écuélé Manga	0	1	Defender	Cardiff City	34	1988-07-16	337	38
Andreas Christensen	0	0	Defender	Chelsea	26	1996-04-10	338	8
Hugo Lloris	0	0	Goalkeeper	Tottenham Hotspur	35	1986-12-26	339	33
Eric Bertrand Bailly	0	0	Defender	Manchester United	28	1994-04-12	340	12
Marouane Fellaini	0	1	Midfielder	Manchester United	34	1987-11-22	341	14
Kasper Schmeichel	0	0	Goalkeeper	Leicester City	35	1986-11-05	342	38
Daniel Amartey	0	0	Midfielder	Leicester City	27	1994-12-21	343	9
Ben Chilwell	0	4	Defender	Leicester City	25	1996-12-21	344	36
Martin Dúbravka	0	0	Goalkeeper	Newcastle United	33	1989-01-15	345	38
Jamal Lascelles	0	1	Defender	Newcastle United	28	1993-11-11	346	32
Paul Dummett	0	0	Defender	Newcastle United	31	1991-09-26	347	26
Mohamed Diamé	0	0	Midfielder	Newcastle United	35	1987-06-14	348	29
Sung-Yeung Ki	0	1	Midfielder	Newcastle United	33	1989-01-24	349	18
Javier Manquillo Gaitán	0	3	Defender	Newcastle United	28	1994-05-05	350	18
Serge Aurier	0	2	Defender	Tottenham Hotspur	29	1992-12-24	351	8
Lee Peltier	0	0	Defender	Cardiff City	35	1986-12-11	352	20
Ben Davies	0	0	Defender	Tottenham Hotspur	29	1993-04-24	353	27
Moussa Sissoko	0	3	Midfielder	Tottenham Hotspur	33	1989-08-16	354	29
Moussa Dembele	0	0	Midfielder	Tottenham Hotspur	35	1987-07-16	355	10
Toby Alderweireld	0	0	Defender	Tottenham Hotspur	33	1989-03-02	356	34
Kyle Walker-Peters	0	3	Defender	Tottenham Hotspur	25	1997-04-13	357	6
Asmir Begović	0	0	Goalkeeper	AFC Bournemouth	35	1987-06-20	358	24
Andrew Surman	0	0	Midfielder	AFC Bournemouth	36	1986-08-20	359	18
Simon Francis	0	2	Defender	AFC Bournemouth	37	1985-02-16	360	17
Artur Boruc	0	0	Goalkeeper	AFC Bournemouth	42	1980-02-20	361	12
Lewis Cook	0	0	Midfielder	AFC Bournemouth	25	1997-02-03	362	13
Neil Leonard Dula Etheridge	0	0	Goalkeeper	Cardiff City	32	1990-02-07	363	38
Kepa Arrizabalaga	0	0	Goalkeeper	Chelsea	28	1994-10-03	364	36
Ben Foster	0	0	Goalkeeper	Watford	39	1983-04-03	365	38
Ederson	0	1	Goalkeeper	Manchester City	29	1993-08-17	366	38
Joe Hart	0	0	Goalkeeper	Burnley	35	1987-04-19	367	19
Arthur Masuaku	0	1	Defender	West Ham United	28	1993-11-07	368	23
Jack Wilshere	0	1	Midfielder	West Ham United	30	1992-01-01	369	8
Pablo Zabaleta	0	1	Defender	West Ham United	37	1985-01-16	370	26
Pedro Obiang	0	1	Midfielder	West Ham United	30	1992-03-27	371	24
Alex McCarthy	0	0	Goalkeeper	Southampton	32	1989-12-03	372	25
Jannik Vestergaard	0	0	Defender	Southampton	30	1992-08-03	373	23
Wesley Hoedt	0	0	Defender	Southampton	28	1994-03-06	374	13
Mohamed Elyounoussi	0	0	Midfielder	Southampton	28	1994-08-04	375	16
Angus Gunn	0	0	Goalkeeper	Southampton	26	1996-01-22	376	12
Jan Bednarek	0	1	Defender	Southampton	26	1996-04-12	377	25
Matthew Lowton	0	0	Defender	Burnley	33	1989-06-09	378	21
Adam David Lallana	0	0	Midfielder	Liverpool	34	1988-05-10	379	13
Ben Mee	0	2	Defender	Burnley	33	1989-09-21	380	38
Charlie Taylor	0	1	Defender	Burnley	29	1993-09-18	381	38
Tom Heaton	0	0	Goalkeeper	Burnley	36	1986-04-15	382	19
Phil Bardsley	0	0	Defender	Burnley	37	1985-06-28	383	19
Petr Čech	0	0	Goalkeeper	Arsenal	40	1982-05-20	384	7
Hector Bellerin	0	5	Defender	Arsenal	27	1995-03-19	385	19
Mattéo Guendouzi Olié	0	0	Midfielder	Arsenal	23	1999-04-14	386	33
Stephan Lichtsteiner	0	0	Defender	Arsenal	38	1984-01-16	387	14
Mohamed Elneny	0	0	Midfielder	Arsenal	30	1992-07-11	388	8
Rob Holding	0	0	Defender	Arsenal	27	1995-09-20	389	10
Bernd Leno	0	0	Goalkeeper	Arsenal	30	1992-03-04	390	32
Łukasz Fabiański	0	0	Goalkeeper	West Ham United	37	1985-04-18	391	38
Nathaniel Clyne	0	1	Defender	AFC Bournemouth	31	1991-04-05	392	18
Christian Kabasele	0	0	Defender	Watford	31	1991-02-24	393	21
Conor Coady	0	0	Midfielder	Wolverhampton Wanderers	29	1993-02-25	394	38
Daryl Janmaat	0	2	Defender	Watford	33	1989-07-22	395	18
Adrian Mariappa	0	0	Defender	Watford	36	1986-10-03	396	26
Adam Masina	0	1	Defender	Watford	28	1994-01-02	397	14
Mathew Ryan	0	0	Goalkeeper	Brighton & Hove Albion	30	1992-04-08	398	34
Bruno Saltor Grau	0	1	Defender	Brighton & Hove Albion	42	1980-10-01	399	14
Bernardo	0	1	Defender	Brighton & Hove Albion	27	1995-05-14	400	22
Gaëtan Bong Songo	0	0	Defender	Brighton & Hove Albion	34	1988-04-25	401	22
Yves Bissouma	0	0	Midfielder	Brighton & Hove Albion	26	1996-08-30	402	28
Alireza Jahanbakhsh	0	0	Forward	Brighton & Hove Albion	29	1993-08-11	403	19
David Button	0	0	Goalkeeper	Brighton & Hove Albion	33	1989-02-27	404	4
Rui Pedro dos Santos Patrício	0	0	Goalkeeper	Wolverhampton Wanderers	34	1988-02-15	405	37
Rúben Gonçalo Silva Nascimento Vinagre	0	0	Defender	Wolverhampton Wanderers	23	1999-04-09	406	17
Joe Gomez	0	0	Defender	Liverpool	25	1997-05-23	407	16
Morgan Gibbs-White	0	1	Midfielder	Wolverhampton Wanderers	22	2000-01-27	408	26
Jordan Pickford	0	0	Goalkeeper	Everton	28	1994-03-07	409	38
Leighton Baines	0	0	Defender	Everton	37	1984-12-11	410	6
Matteo Darmian	0	0	Defender	Manchester United	32	1989-12-02	411	6
Morgan Schneiderlin	0	1	Midfielder	Everton	32	1989-11-08	412	14
Idrissa Gana Gueye	0	2	Midfielder	Everton	33	1989-09-26	413	33
Mason Holgate	0	0	Defender	Everton	26	1996-10-22	414	5
Oumar Niasse	0	0	Forward	Cardiff City	32	1990-04-18	415	18
Tom Davies	0	0	Midfielder	Everton	24	1998-06-30	416	16
Alisson Becker	0	0	Goalkeeper	Liverpool	30	1992-10-02	417	38
Andrew Robertson	0	11	Defender	Liverpool	28	1994-03-11	418	36
Håvard Nordtveit	0	1	Midfielder	Fulham	32	1990-06-21	419	5

Best Midfielder

A midfielders job is to make sure that they are an open to passing, assisting people in getting their goals, and making sure the ball stays on the attack.

Mid <- filter(df, rank_in_league_top_midfielders != -1) %>% 
  select(c('full_name','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_midfielders', 'appearances_overall' )) 

MidClean <- Mid[order(Mid$rank_in_league_top_midfielders),]

kable(MidClean, format = "html" , caption = "Top league Midfielders",align = "cccccccccccccccc") %>% kable_styling()

Top league Midfielders
full_name	assists_overall	position	current_club	age	birthday_gmt	rank_in_league_top_midfielders	appearances_overall
Kyle Walker-Peters	3	Defender	Tottenham Hotspur	25	1997-04-13	1	6
Fernando Llorente Torres	4	Forward	Tottenham Hotspur	37	1985-02-26	2	20
Benjamin Mendy	5	Defender	Manchester City	28	1994-07-17	3	10
Leroy Sané	10	Midfielder	Manchester City	26	1996-01-11	4	31
Eden Hazard	15	Midfielder	Chelsea	31	1991-01-07	5	37
Trent Alexander-Arnold	12	Defender	Liverpool	24	1998-10-07	6	29
Olivier Giroud	4	Forward	Chelsea	36	1986-09-30	7	27
Aaron Ramsey	6	Midfielder	Arsenal	31	1990-12-26	8	28
Ryan Fraser	14	Midfielder	AFC Bournemouth	28	1994-02-24	9	38
Christian Eriksen	12	Midfielder	Tottenham Hotspur	30	1992-02-14	10	35
Luciano Vietto	4	Forward	Fulham	28	1993-12-05	11	20
Ross Barkley	5	Midfielder	Chelsea	28	1993-12-05	12	27
Youri Tielemans	4	Midfielder	Leicester City	25	1997-05-07	13	13
Raheem Sterling	10	Forward	Manchester City	27	1994-12-08	14	34
Serge Aurier	2	Defender	Tottenham Hotspur	29	1992-12-24	15	8
Callum Wilson	9	Forward	AFC Bournemouth	30	1992-02-27	16	30
Alexis Sanchez	3	Forward	Manchester United	33	1988-12-19	17	20
Johann Berg Guðmundsson	6	Midfielder	Burnley	32	1990-10-27	18	29
Andrew Robertson	11	Defender	Liverpool	28	1994-03-11	19	36
Ademola Lookman	2	Forward	Everton	25	1997-10-20	20	21
Jacob Murphy	1	Midfielder	Newcastle United	27	1995-02-24	21	9
David Silva	8	Midfielder	Manchester City	36	1986-01-08	22	33
Matěj Vydra	1	Forward	Burnley	30	1992-05-01	23	13
Kelechi Iheanacho	3	Forward	Leicester City	26	1996-10-03	24	30
Alexandre Lacazette	8	Forward	Arsenal	31	1991-05-28	25	35
Hector Bellerin	5	Defender	Arsenal	27	1995-03-19	26	19
Anthony Knockaert	6	Midfielder	Brighton & Hove Albion	30	1991-11-20	27	30
Sergio Aguero	8	Forward	Manchester City	34	1988-06-02	28	33
Dwight McNeil	5	Forward	Burnley	22	1999-11-22	29	21
Paul Pogba	9	Midfielder	Manchester United	29	1993-03-15	30	35
Alex Iwobi	6	Forward	Arsenal	26	1996-05-03	31	35
Riyad Mahrez	4	Midfielder	Manchester City	31	1991-02-21	32	27
Gabriel Jesus	3	Forward	Manchester City	25	1997-04-03	33	29
Heung-Min Son	6	Forward	Tottenham Hotspur	30	1992-07-08	34	31
Junior Stanislas	3	Midfielder	AFC Bournemouth	32	1989-11-26	35	23
Willian	6	Forward	Chelsea	34	1988-08-09	36	32
Cenk Tosun	3	Forward	Everton	31	1991-06-07	37	25
Dominic Solanke	1	Forward	AFC Bournemouth	25	1997-09-14	38	10
Xherdan Shaqiri	3	Midfielder	Liverpool	31	1991-10-10	39	24
Javier Manquillo Gaitán	3	Defender	Newcastle United	28	1994-05-05	40	18
Håvard Nordtveit	1	Midfielder	Fulham	32	1990-06-21	41	5
Divock Origi	1	Forward	Liverpool	27	1995-04-18	42	12
Rondon	7	Forward	Newcastle United	33	1989-09-16	43	32
João Moutinho	8	Midfielder	Wolverhampton Wanderers	36	1986-09-08	44	38
Sead Kolašinac	5	Defender	Arsenal	29	1993-06-20	45	24
Matt Ritchie	8	Midfielder	Newcastle United	33	1989-09-10	46	36
Ken Sema	2	Midfielder	Watford	29	1993-09-30	47	17
Jack Wilshere	1	Midfielder	West Ham United	30	1992-01-01	48	8
José Holebas	6	Defender	Watford	38	1984-06-27	49	28
Oleksandr Zinchenko	3	Midfielder	Manchester City	25	1996-12-15	50	14
Matt Targett	3	Defender	Southampton	27	1995-09-18	51	16
Marcus Rashford	6	Forward	Manchester United	25	1997-10-31	52	33
Ryan Sessegnon	6	Defender	Fulham	22	2000-05-18	53	35
Callum Hudson-Odoi	1	Midfielder	Chelsea	21	2000-11-07	54	10
Ashley Westwood	7	Midfielder	Burnley	32	1990-04-01	55	34
Henrikh Mkhitaryan	4	Midfielder	Arsenal	33	1989-01-21	56	25
Mohamed Salah	8	Forward	Liverpool	30	1992-06-15	57	38
Bernardo Silva	7	Midfielder	Manchester City	28	1994-08-10	58	36
Gerard Deulofeu	5	Forward	Watford	28	1994-03-13	59	30
James Maddison	7	Midfielder	Leicester City	25	1996-11-23	60	36
Ryan Guno Babel	3	Forward	Fulham	35	1986-12-19	61	16
Roberto Firmino	6	Forward	Liverpool	31	1991-10-02	62	34
Raúl Alonso Jiménez Rodríguez	7	Forward	Wolverhampton Wanderers	31	1991-05-05	63	38
Robert Snodgrass	5	Midfielder	West Ham United	35	1987-09-07	64	33
James Milner	4	Midfielder	Liverpool	36	1986-01-04	65	31
David Brooks	5	Forward	AFC Bournemouth	25	1997-07-08	66	30
Isaac Hayden	4	Midfielder	Newcastle United	27	1995-03-22	67	25
Ander Herrera	3	Midfielder	Manchester United	33	1989-08-14	68	22
Erik Lamela	2	Midfielder	Tottenham Hotspur	30	1992-03-04	69	19
Mark Noble	5	Midfielder	West Ham United	35	1987-05-08	70	31
Diogo José Teixeira da Silva	5	Midfielder	Wolverhampton Wanderers	25	1996-12-04	71	33
Kevin Long	1	Defender	Burnley	32	1990-08-18	72	6
Charlie Austin	2	Forward	Southampton	33	1989-07-05	73	25
James McArthur	6	Midfielder	Crystal Palace	35	1987-10-07	74	38
Kevin De Bruyne	2	Midfielder	Manchester City	31	1991-06-28	75	19
Marko Arnautović	4	Forward	West Ham United	33	1989-04-19	76	28
José Diogo Dalot Teixeira	2	Defender	Manchester United	23	1999-03-18	77	16
Harvey Lewis Barnes	2	Midfielder	Leicester City	24	1997-12-09	78	16
Daniel Sturridge	1	Forward	Liverpool	33	1989-09-01	79	18
Abdoulaye Doucouré	6	Midfielder	Watford	29	1993-01-01	80	35
Troy Deeney	5	Forward	Watford	34	1988-06-29	81	32
Solomon March	5	Midfielder	Brighton & Hove Albion	28	1994-07-20	82	35
Ruben Loftus-Cheek	2	Midfielder	Chelsea	26	1996-01-23	83	24
Ricardo Domingos Barbosa Pereira	6	Defender	Leicester City	29	1993-10-06	84	35
Michail Antonio	4	Midfielder	West Ham United	32	1990-03-28	85	33
Gylfi Sigurdsson	6	Midfielder	Everton	33	1989-09-08	86	38
Daniel William John Ings	3	Forward	Southampton	30	1992-07-23	87	24
Pierre-Emerick Aubameyang	5	Forward	Arsenal	33	1989-06-18	88	36
Grady Diangana	1	Midfielder	West Ham United	24	1998-04-19	89	17
Steve Mounié	3	Forward	Huddersfield Town	28	1994-09-29	90	31
Will Hughes	4	Midfielder	Watford	27	1995-04-17	91	32
Wilfried Zaha	5	Midfielder	Crystal Palace	29	1992-11-10	92	34
Andreas Pereira	1	Midfielder	Manchester United	26	1996-01-01	93	15
Harry Kane	4	Forward	Tottenham Hotspur	29	1993-07-28	94	28
Danny Rose	3	Defender	Tottenham Hotspur	32	1990-07-02	95	26
Jordan Ayew	2	Forward	Crystal Palace	31	1991-09-11	96	20
Dele Alli	3	Midfielder	Tottenham Hotspur	26	1996-04-11	97	25
Nacho Monreal	3	Defender	Arsenal	36	1986-02-26	98	22
Simon Francis	2	Defender	AFC Bournemouth	37	1985-02-16	99	17
Matt Doherty	5	Defender	Wolverhampton Wanderers	30	1992-01-16	100	38
Scott Dann	1	Defender	Crystal Palace	35	1987-02-14	101	10
Jordan Henderson	3	Midfielder	Liverpool	32	1990-06-17	102	32
Juan Mata	2	Midfielder	Manchester United	34	1988-04-28	103	22
Pascal Groß	3	Midfielder	Brighton & Hove Albion	31	1991-06-15	104	25
Luke Shaw	4	Defender	Manchester United	27	1995-07-12	105	29
Víctor Camarasa	4	Midfielder	Cardiff City	28	1994-05-28	106	32
Morgan Gibbs-White	1	Midfielder	Wolverhampton Wanderers	22	2000-01-27	107	26
Robbie Brady	1	Midfielder	Burnley	30	1992-01-14	108	16
Andre Gray	2	Forward	Watford	31	1991-06-26	109	29
Max Meyer	2	Midfielder	Crystal Palace	27	1995-09-18	110	29
Manuel Lanzini	1	Midfielder	West Ham United	29	1993-02-15	111	10
Marcos Alonso	4	Defender	Chelsea	31	1990-12-28	112	31
Hélder Wander Sousa Azevedo Costa	2	Midfielder	Wolverhampton Wanderers	28	1994-01-12	113	25
Stuart Armstrong	2	Midfielder	Southampton	30	1992-03-30	114	29
Bobby Reid	2	Midfielder	Cardiff City	29	1993-02-02	115	27
Cesar Azpilicueta	5	Defender	Chelsea	33	1989-08-28	116	38
Bernard Anício Caldeira Duarte	3	Midfielder	Everton	30	1992-09-08	117	34
Jamie Vardy	4	Forward	Leicester City	35	1987-01-11	118	34
Ivan Ricardo Neves Abreu Cavaleiro	1	Forward	Wolverhampton Wanderers	29	1993-10-18	119	23
İlkay Gündoğan	3	Midfielder	Manchester City	32	1990-10-24	120	31
Daryl Janmaat	2	Defender	Watford	33	1989-07-22	121	18
Kieran Trippier	3	Defender	Tottenham Hotspur	32	1990-09-19	122	27
Fabian Delph	1	Midfielder	Manchester City	32	1989-11-21	123	11
Cedric Soares	2	Defender	Southampton	31	1991-08-31	124	18
Lucas Digne	4	Defender	Everton	29	1993-07-20	125	35
N’Golo Kanté	4	Midfielder	Chelsea	31	1991-03-29	126	36
Andros Townsend	4	Midfielder	Crystal Palace	31	1991-07-16	127	38
Kenneth Dahrup Zohorè	1	Forward	Cardiff City	28	1994-01-31	128	19
Marouane Fellaini	1	Midfielder	Manchester United	34	1987-11-22	129	14
Felipe Anderson Pereira Gomes	4	Midfielder	West Ham United	29	1993-04-15	130	36
Moussa Sissoko	3	Midfielder	Tottenham Hotspur	33	1989-08-16	131	29
Fernando Luiz Rosa	3	Midfielder	Manchester City	37	1985-05-04	132	29
Chris Mepham	1	Defender	AFC Bournemouth	24	1997-11-05	133	13
Jordon Ibe	1	Midfielder	AFC Bournemouth	26	1995-12-08	134	19
Jesse Lingard	2	Midfielder	Manchester United	29	1992-12-15	135	27
Jose Izquierdo	1	Forward	Brighton & Hove Albion	30	1992-07-07	136	15
Nathan Redmond	4	Midfielder	Southampton	28	1994-03-06	137	38
Morgan Schneiderlin	1	Midfielder	Everton	32	1989-11-08	138	14
Ben Chilwell	4	Defender	Leicester City	25	1996-12-21	139	36
Marc Albrighton	2	Midfielder	Leicester City	32	1989-11-18	140	27
Anthony Martial	2	Forward	Manchester United	26	1995-12-05	141	27
Christian Benteke	1	Forward	Crystal Palace	31	1990-12-03	142	16
Jonjoe Kenny	1	Defender	Everton	25	1997-03-15	143	10
Pedro Rodriguez	2	Midfielder	Chelsea	35	1987-07-28	144	31
Dominic Calvert-Lewin	2	Forward	Everton	25	1997-03-16	145	35
Beram Kayal	1	Midfielder	Brighton & Hove Albion	34	1988-05-02	146	18
Josh Murphy	2	Forward	Cardiff City	27	1995-02-24	147	29
Pierre-Emile Højbjerg	3	Midfielder	Southampton	27	1995-08-05	148	31
Jonjo Shelvey	1	Midfielder	Newcastle United	30	1992-02-27	149	16
Mateo Kovačić	2	Midfielder	Chelsea	28	1994-05-06	150	32
Mesut Özil	2	Midfielder	Arsenal	34	1988-10-15	151	24
Adama Traoré Diarra	1	Midfielder	Wolverhampton Wanderers	26	1996-01-25	152	29
Etienne Capoue	3	Midfielder	Watford	34	1988-07-11	153	33
Isaac Ajayi Success	1	Forward	Watford	26	1996-01-07	154	30
Adam Masina	1	Defender	Watford	28	1994-01-02	155	14
Frederico Rodrigues Santos	1	Midfielder	Manchester United	29	1993-03-05	156	17
Joshua King	3	Forward	AFC Bournemouth	30	1992-01-15	157	35
Aymeric Laporte	3	Defender	Manchester City	28	1994-05-27	158	35
Nathaniel Mendez-Laing	1	Midfielder	Cardiff City	30	1992-04-15	159	20
Aaron Wan-Bissaka	3	Midfielder	Crystal Palace	24	1997-11-26	160	35
Cheikhou Kouyaté	2	Midfielder	Crystal Palace	32	1989-12-21	161	31
Rúben Diogo Da Silva Neves	3	Midfielder	Wolverhampton Wanderers	25	1997-03-13	162	35
Chris Löwe	2	Defender	Huddersfield Town	33	1989-04-16	163	29
Sean Morrison	3	Defender	Cardiff City	31	1991-01-08	164	34
Isaac Mbenza	1	Forward	Huddersfield Town	26	1996-03-08	165	22
Fabinho	2	Midfielder	Liverpool	29	1993-10-23	166	28
Ainsley Maitland-Niles	1	Midfielder	Arsenal	25	1997-08-29	167	16
Pedro Obiang	1	Midfielder	West Ham United	30	1992-03-27	168	24
Laurent Depoitre	1	Forward	Huddersfield Town	33	1988-12-07	169	23
Theo Walcott	2	Forward	Everton	33	1989-03-16	170	37
Jean Michau00ebl Seri	2	Midfielder	Fulham	31	1991-07-19	171	32
Ashley Barnes	2	Forward	Burnley	32	1989-10-30	172	37
Sokratis Papastathopoulos	2	Defender	Arsenal	34	1988-06-09	173	25
Lucas Torreira	2	Midfielder	Arsenal	26	1996-02-11	174	34
Bruno Saltor Grau	1	Defender	Brighton & Hove Albion	42	1980-10-01	175	14
Aleksandar Mitrović	3	Forward	Fulham	28	1994-09-16	176	37
DeAndre Yedlin	2	Defender	Newcastle United	29	1993-07-09	177	29
Séamus Coleman	2	Defender	Everton	34	1988-10-11	178	29
Sung-Yeung Ki	1	Midfielder	Newcastle United	33	1989-01-24	179	18
Nathaniel Clyne	1	Defender	AFC Bournemouth	31	1991-04-05	180	18
Ashley Young	2	Midfielder	Manchester United	37	1985-07-09	181	30
Shane Long	1	Forward	Southampton	35	1987-01-22	182	26
Granit Xhaka	2	Midfielder	Arsenal	30	1992-09-27	183	29
Robert Kenedy Nunes do Nascimento	1	Midfielder	Newcastle United	26	1996-02-08	184	25
Kurt Zouma	2	Defender	Everton	28	1994-10-27	185	32
Javier Hernandez	1	Forward	West Ham United	34	1988-06-01	186	25
Aaron Lennon	1	Midfielder	Burnley	35	1987-04-16	187	16
Chris Wood	2	Forward	Burnley	30	1991-12-07	188	38
Phil Jones	1	Defender	Manchester United	30	1992-02-21	189	18
Naby Deco Keïta	1	Midfielder	Liverpool	27	1995-02-10	190	25
Aaron Cresswell	1	Defender	West Ham United	32	1989-12-15	191	20
Maya Yoshida	1	Defender	Southampton	34	1988-08-24	192	17
Idrissa Gana Gueye	2	Midfielder	Everton	33	1989-09-26	193	33
Federico Fernández	1	Defender	Newcastle United	33	1989-02-21	194	19
Mario Lemina	1	Midfielder	Southampton	29	1993-09-01	195	21
Michael Keane	2	Defender	Everton	29	1993-01-11	196	33
Ayoze Perez	2	Forward	Newcastle United	29	1993-07-29	197	37
David Luiz	2	Defender	Chelsea	35	1987-04-22	198	36
Patrick van Aanholt	2	Defender	Crystal Palace	32	1990-08-29	199	36
Bernardo	1	Defender	Brighton & Hove Albion	27	1995-05-14	200	22
Virgil van Dijk	2	Defender	Liverpool	31	1991-07-08	201	38
Callum Paterson	1	Defender	Cardiff City	28	1994-10-13	202	27
Arthur Masuaku	1	Defender	West Ham United	28	1993-11-07	203	23
Jack Cork	2	Midfielder	Burnley	33	1989-06-25	204	37
Cyrus Christie	1	Defender	Fulham	30	1992-09-30	205	28
Dan Gosling	1	Midfielder	AFC Bournemouth	32	1990-02-01	206	25
Angelo Ogbonna	1	Defender	West Ham United	34	1988-05-23	207	24
Davinson Sánchez Mina	1	Defender	Tottenham Hotspur	26	1996-06-12	208	23
Jeffrey Schlupp	1	Defender	Crystal Palace	29	1992-12-23	209	30
Luka Milivojević	2	Midfielder	Crystal Palace	31	1991-04-07	210	38
Ben Mee	2	Defender	Burnley	33	1989-09-21	211	38
Demarai Gray	1	Midfielder	Leicester City	26	1996-06-28	212	34
André Filipe Tavares Gomes	1	Midfielder	Everton	29	1993-07-30	213	27
Yann Valery	1	Defender	Southampton	23	1999-02-22	214	23
James Tomkins	1	Defender	Crystal Palace	33	1989-03-29	215	29
Francisco Femenía Far	1	Midfielder	Watford	31	1991-02-02	216	29
Tom Cairney	1	Midfielder	Fulham	31	1991-01-20	217	31
Joe Bryan	1	Defender	Fulham	29	1993-09-17	218	28
Maxime Le Marchand	1	Defender	Fulham	33	1989-10-11	219	26
David Junior Hoilett	1	Forward	Cardiff City	32	1990-06-05	220	32
Harry Arter	1	Midfielder	Cardiff City	32	1989-12-28	221	25
Souleymane Bamba	1	Defender	Cardiff City	37	1985-01-13	222	28
Pablo Zabaleta	1	Defender	West Ham United	37	1985-01-16	223	26
Dale Stephens	1	Midfielder	Brighton & Hove Albion	33	1989-06-12	224	30
Jan Bednarek	1	Defender	Southampton	26	1996-04-12	225	25
Davy Pröpper	1	Midfielder	Brighton & Hove Albion	31	1991-09-02	226	30
Glenn Murray	1	Forward	Brighton & Hove Albion	39	1983-09-25	227	38
Adam Smith	1	Defender	AFC Bournemouth	31	1991-04-29	228	25
Martín Montoya	1	Defender	Brighton & Hove Albion	31	1991-04-14	229	25
Fabian Schär	1	Defender	Newcastle United	30	1991-12-20	230	24
Jonathan Hogg	1	Midfielder	Huddersfield Town	33	1988-12-06	231	29
Erik Durm	1	Defender	Huddersfield Town	30	1992-05-12	232	28
Aaron Mooy	1	Midfielder	Huddersfield Town	32	1990-09-15	233	29
Aron Einar Gunnarsson	1	Midfielder	Cardiff City	33	1989-04-22	234	28
Mathias Jattah-Njie Jørgensen	1	Defender	Huddersfield Town	32	1990-04-23	235	24
Terence Kongolo	1	Defender	Huddersfield Town	28	1994-02-14	236	32
Jonny	1	Defender	Wolverhampton Wanderers	28	1994-03-03	237	33
James Tarkowski	1	Defender	Burnley	29	1992-11-19	238	35
Charlie Taylor	1	Defender	Burnley	29	1993-09-18	239	38
Ederson	1	Goalkeeper	Manchester City	29	1993-08-17	240	38
Joe Bennett	1	Defender	Cardiff City	32	1990-03-28	241	30
Bruno Écuélé Manga	1	Defender	Cardiff City	34	1988-07-16	242	38
Steve Cook	1	Defender	AFC Bournemouth	31	1991-04-19	243	31
Denis Odoi	1	Defender	Fulham	34	1988-05-27	244	31
Jamal Lascelles	1	Defender	Newcastle United	28	1993-11-11	245	32
Victor Nilsson Lindelöf	1	Defender	Manchester United	28	1994-07-17	246	30
Jonas Lössl	1	Goalkeeper	Huddersfield Town	33	1989-02-01	247	31
Kyle Walker	1	Defender	Manchester City	32	1990-05-28	248	33
Sadio Mané	1	Forward	Liverpool	30	1992-04-10	249	36
Richarlison de Andrade	1	Forward	Everton	25	1997-05-10	250	35
Roberto Maximiliano Pereyra	1	Forward	Watford	31	1991-01-07	251	33
Lewis Dunk	1	Defender	Brighton & Hove Albion	30	1991-11-21	252	36
Shane Duffy	1	Defender	Brighton & Hove Albion	30	1992-01-01	253	35
Charlie Daniels	0	Defender	AFC Bournemouth	36	1986-09-07	254	21
Alfie Mawson	0	Defender	Fulham	28	1994-01-19	255	15
Antonio Valencia	0	Defender	Manchester United	37	1985-08-04	256	6
Nemanja Matić	0	Midfielder	Manchester United	34	1988-08-01	257	28
Jason Puncheon	0	Midfielder	Huddersfield Town	36	1986-06-26	258	11
Elias Kachunga	0	Forward	Huddersfield Town	30	1992-04-22	259	20
Jordan Pickford	0	Goalkeeper	Everton	28	1994-03-07	260	38
Diego Rico	0	Defender	AFC Bournemouth	29	1993-02-23	261	12
Kadeem Harris	0	Midfielder	Cardiff City	29	1993-06-08	262	13
Sean Longstaff	0	Midfielder	Newcastle United	25	1997-10-30	263	9
Romain Saïss	0	Midfielder	Wolverhampton Wanderers	32	1990-03-26	264	19
José Luis Sanmartín Mato	0	Forward	Newcastle United	32	1990-03-27	265	16
Victor Wanyama	0	Midfielder	Tottenham Hotspur	31	1991-06-25	266	13
Mohamed Diamé	0	Midfielder	Newcastle United	35	1987-06-14	267	29
Floyd Ayité	0	Midfielder	Fulham	33	1988-12-15	268	16
Paul Dummett	0	Defender	Newcastle United	31	1991-09-26	269	26
Alireza Jahanbakhsh	0	Forward	Brighton & Hove Albion	29	1993-08-11	270	19
Christian Atsu Twasam	0	Midfielder	Newcastle United	30	1992-01-10	271	28
Phil Jagielka	0	Defender	Everton	40	1982-08-17	272	7
Asmir Begović	0	Goalkeeper	AFC Bournemouth	35	1987-06-20	273	24
Ben Davies	0	Defender	Tottenham Hotspur	29	1993-04-24	274	27
Toby Alderweireld	0	Defender	Tottenham Hotspur	33	1989-03-02	275	34
Lucas Perez	0	Forward	West Ham United	34	1988-09-10	276	15
Moussa Dembele	0	Midfielder	Tottenham Hotspur	35	1987-07-16	277	10
Eric Dier	0	Midfielder	Tottenham Hotspur	28	1994-01-15	278	20
Lucas Rodrigues Moura da Silva	0	Midfielder	Tottenham Hotspur	30	1992-08-13	279	32
Matteo Darmian	0	Defender	Manchester United	32	1989-12-02	280	6
Jürgen Locadia	0	Forward	Brighton & Hove Albion	28	1993-11-07	281	26
Jan Vertonghen	0	Defender	Tottenham Hotspur	35	1987-04-24	282	22
Marcus Bettinelli	0	Goalkeeper	Fulham	30	1992-05-24	283	7
Hugo Lloris	0	Goalkeeper	Tottenham Hotspur	35	1986-12-26	284	33
André-Frank Zambo Anguissa	0	Midfielder	Fulham	26	1995-11-16	285	22
Joel Matip	0	Defender	Liverpool	31	1991-08-08	286	22
Leighton Baines	0	Defender	Everton	37	1984-12-11	287	6
Jefferson Lerma	0	Midfielder	AFC Bournemouth	28	1994-10-25	288	30
Florin Andone	0	Forward	Brighton & Hove Albion	29	1993-04-11	289	23
Yoshinori Muto	0	Forward	Newcastle United	30	1992-07-15	290	17
Jon Gorenc Stankovič	0	Defender	Huddersfield Town	26	1996-01-14	291	11
Leon Balogun	0	Defender	Brighton & Hove Albion	34	1988-06-28	292	8
Yves Bissouma	0	Midfielder	Brighton & Hove Albion	26	1996-08-30	293	28
Chris Smalling	0	Defender	Manchester United	32	1989-11-22	294	24
Laurent Koscielny	0	Defender	Arsenal	37	1985-09-10	295	17
Emerson Palmieri dos Santos	0	Defender	Chelsea	28	1994-08-03	296	10
Hamza Choudhury	0	Midfielder	Leicester City	25	1997-10-01	297	9
Tom Cleverley	0	Midfielder	Watford	33	1989-08-12	298	13
Harry Maguire	0	Defender	Leicester City	29	1993-03-05	299	31
Wes Morgan	0	Defender	Leicester City	38	1984-01-21	300	22
Florian Lejeune	0	Defender	Newcastle United	31	1991-05-20	301	12
Kasper Schmeichel	0	Goalkeeper	Leicester City	35	1986-11-05	302	38
Scott McTominay	0	Midfielder	Manchester United	25	1996-12-08	303	16
Ryan Bennett	0	Defender	Wolverhampton Wanderers	32	1990-03-06	304	34
Romelu Lukaku	0	Forward	Manchester United	29	1993-05-13	305	32
Gonzalo Higuain	0	Forward	Chelsea	34	1987-12-10	306	14
Michy Batshuayi	0	Forward	Crystal Palace	29	1993-10-02	307	11
Karlan Ahearne-Grant	0	Forward	Huddersfield Town	24	1997-12-19	308	13
Leandro Bacuna	0	Midfielder	Cardiff City	31	1991-08-21	309	11
Eric Bertrand Bailly	0	Defender	Manchester United	28	1994-04-12	310	12
Miguel Ángel Almirón Rejala	0	Midfielder	Newcastle United	28	1994-02-10	311	10
Willy Boly	0	Defender	Wolverhampton Wanderers	31	1991-02-03	312	36
Daniel Amartey	0	Midfielder	Leicester City	27	1994-12-21	313	9
Jack Simpson	0	Defender	AFC Bournemouth	25	1996-12-18	314	6
Ciaran Clark	0	Defender	Newcastle United	33	1989-09-26	315	11
Domingos Quina	0	Midfielder	Watford	22	1999-11-18	316	8
Martin Dúbravka	0	Goalkeeper	Newcastle United	33	1989-01-15	317	38
Danilo	0	Defender	Manchester City	31	1991-07-15	318	11
Jonny Evans	0	Defender	Leicester City	34	1988-01-03	319	24
Tim Ream	0	Defender	Fulham	35	1987-10-05	320	26
Steven Defour	0	Midfielder	Burnley	34	1988-04-15	321	6
Rachid Ghezzal	0	Forward	Leicester City	30	1992-05-09	322	19
Rúben Gonçalo Silva Nascimento Vinagre	0	Defender	Wolverhampton Wanderers	23	1999-04-09	323	17
Dejan Lovren	0	Defender	Liverpool	33	1989-07-05	324	13
Juninho Bacuna	0	Midfielder	Huddersfield Town	25	1997-08-07	325	21
Andy Carroll	0	Forward	West Ham United	33	1989-01-06	326	12
David Button	0	Goalkeeper	Brighton & Hove Albion	33	1989-02-27	327	4
Rui Pedro dos Santos Patrício	0	Goalkeeper	Wolverhampton Wanderers	34	1988-02-15	328	37
Yerry Fernando Mina González	0	Defender	Everton	28	1994-09-23	329	13
Caglar Söyüncü	0	Defender	Leicester City	26	1996-05-23	330	6
Leander Dendoncker	0	Midfielder	Wolverhampton Wanderers	27	1995-04-15	331	19
Onyinye Wilfred Ndidi	0	Midfielder	Leicester City	25	1996-12-16	332	38
Danny Simpson	0	Defender	Leicester City	35	1987-01-04	333	6
Juan Marcos Foyth	0	Defender	Tottenham Hotspur	24	1998-01-12	334	12
Harry Winks	0	Midfielder	Tottenham Hotspur	26	1996-02-02	335	26
Gaëtan Bong Songo	0	Defender	Brighton & Hove Albion	34	1988-04-25	336	22
Nathan Aké	0	Defender	AFC Bournemouth	27	1995-02-18	337	38
Alvaro Morata	0	Forward	Chelsea	30	1992-10-23	338	16
Angus Gunn	0	Goalkeeper	Southampton	26	1996-01-22	339	12
Ryan Fredericks	0	Midfielder	West Ham United	30	1992-10-10	340	15
Joe Hart	0	Goalkeeper	Burnley	35	1987-04-19	341	19
Matthew Lowton	0	Defender	Burnley	33	1989-06-09	342	21
Łukasz Fabiański	0	Goalkeeper	West Ham United	37	1985-04-18	343	38
Adam David Lallana	0	Midfielder	Liverpool	34	1988-05-10	344	13
Christopher Schindler	0	Defender	Huddersfield Town	32	1990-04-29	345	37
Andreas Christensen	0	Defender	Chelsea	26	1996-04-10	346	8
James Ward-Prowse	0	Midfielder	Southampton	27	1994-11-01	347	26
Ben Hamer	0	Goalkeeper	Huddersfield Town	34	1987-11-20	348	7
Jeff Hendrick	0	Midfielder	Burnley	30	1992-01-31	349	32
Martin Kelly	0	Defender	Crystal Palace	32	1990-04-27	350	13
Sam Vokes	0	Forward	Burnley	33	1989-10-21	351	20
Vicente Guaita	0	Goalkeeper	Crystal Palace	35	1987-01-10	352	20
Ben Foster	0	Goalkeeper	Watford	39	1983-04-03	353	38
Tom Heaton	0	Goalkeeper	Burnley	36	1986-04-15	354	19
Phil Bardsley	0	Defender	Burnley	37	1985-06-28	355	19
Fabián Cornelio Balbuena González	0	Defender	West Ham United	31	1991-08-23	356	23
Manolo Gabbiadini	0	Forward	Southampton	30	1991-11-26	357	12
Joel Ward	0	Defender	Crystal Palace	32	1989-10-29	358	7
Adama Diakhaby	0	Forward	Huddersfield Town	26	1996-07-05	359	12
Tom Smith	0	Defender	Huddersfield Town	30	1992-04-14	360	15
Andriy Yarmolenko	0	Forward	West Ham United	33	1989-10-23	361	9
Declan Rice	0	Midfielder	West Ham United	23	1999-01-14	362	34
Kepa Arrizabalaga	0	Goalkeeper	Chelsea	28	1994-10-03	363	36
Issa Diop	0	Defender	West Ham United	25	1997-01-09	364	33
Alex McCarthy	0	Goalkeeper	Southampton	32	1989-12-03	365	25
Ryan Bertrand	0	Defender	Southampton	33	1989-08-05	366	24
Jannik Vestergaard	0	Defender	Southampton	30	1992-08-03	367	23
Mohamed Elyounoussi	0	Midfielder	Southampton	28	1994-08-04	368	16
Jack Stephens	0	Defender	Southampton	28	1994-01-27	369	24
Wesley Hoedt	0	Defender	Southampton	28	1994-03-06	370	13
Oriol Romeu	0	Midfielder	Southampton	31	1991-09-24	371	31
Philip Billing	0	Midfielder	Huddersfield Town	26	1996-06-11	372	27
Alex Pritchard	0	Midfielder	Huddersfield Town	29	1993-05-03	373	30
Antonio Rüdiger	0	Defender	Chelsea	29	1993-03-03	374	33
Jorginho	0	Midfielder	Chelsea	30	1991-12-20	375	37
Florent Hadergjonaj	0	Defender	Huddersfield Town	28	1994-07-31	376	24
Petr Čech	0	Goalkeeper	Arsenal	40	1982-05-20	377	7
Shkodran Mustafi	0	Defender	Arsenal	30	1992-04-17	378	31
Andrew Surman	0	Midfielder	AFC Bournemouth	36	1986-08-20	379	18
Tom Davies	0	Midfielder	Everton	24	1998-06-30	380	16
Greg Cunningham	0	Defender	Cardiff City	31	1991-01-31	381	7
Danny Ward	0	Forward	Cardiff City	31	1990-12-09	382	14
Joe Ralls	0	Midfielder	Cardiff City	29	1993-10-13	383	28
Vincent Kompany	0	Defender	Manchester City	36	1986-04-10	384	17
Nicolas Otamendi	0	Defender	Manchester City	34	1988-02-12	385	18
Philip Foden	0	Midfielder	Manchester City	22	2000-05-28	386	13
Alisson Becker	0	Goalkeeper	Liverpool	30	1992-10-02	387	38
Oumar Niasse	0	Forward	Cardiff City	32	1990-04-18	388	18
Mathew Ryan	0	Goalkeeper	Brighton & Hove Albion	30	1992-04-08	389	34
Mason Holgate	0	Defender	Everton	26	1996-10-22	390	5
Lee Peltier	0	Defender	Cardiff City	35	1986-12-11	391	20
Neil Leonard Dula Etheridge	0	Goalkeeper	Cardiff City	32	1990-02-07	392	38
Lewis Cook	0	Midfielder	AFC Bournemouth	25	1997-02-03	393	13
Artur Boruc	0	Goalkeeper	AFC Bournemouth	42	1980-02-20	394	12
Lys Mousset	0	Forward	AFC Bournemouth	26	1996-02-08	395	24
Rajiv van La Parra	0	Midfielder	Huddersfield Town	31	1991-06-04	396	5
Nampalys Mendy	0	Midfielder	Leicester City	30	1992-06-23	397	31
Joe Gomez	0	Defender	Liverpool	25	1997-05-23	398	16
Calum Chambers	0	Defender	Fulham	27	1995-01-20	399	31
Craig Cathcart	0	Defender	Watford	33	1989-02-06	400	36
Stefan Marius Johansen	0	Midfielder	Fulham	31	1991-01-08	401	12
Christian Kabasele	0	Defender	Watford	31	1991-02-24	402	21
Mamadou Sakho	0	Defender	Crystal Palace	32	1990-02-13	403	27
Wayne Hennessey	0	Goalkeeper	Crystal Palace	35	1987-01-24	404	18
Mattéo Guendouzi Olié	0	Midfielder	Arsenal	23	1999-04-14	405	33
Sergio Rico	0	Goalkeeper	Fulham	29	1993-09-01	406	29
Stephan Lichtsteiner	0	Defender	Arsenal	38	1984-01-16	407	14
Timothy Fosu-Mensah	0	Defender	Fulham	24	1998-01-02	408	12
Mohamed Elneny	0	Midfielder	Arsenal	30	1992-07-11	409	8
Kevin McDonald	0	Midfielder	Fulham	33	1988-11-04	410	15
Rob Holding	0	Defender	Arsenal	27	1995-09-20	411	10
Aboubakar Kamara	0	Forward	Fulham	27	1995-03-07	412	13
Bernd Leno	0	Goalkeeper	Arsenal	30	1992-03-04	413	32
Adrian Mariappa	0	Defender	Watford	36	1986-10-03	414	26
Conor Coady	0	Midfielder	Wolverhampton Wanderers	29	1993-02-25	415	38
Georginio Wijnaldum	0	Midfielder	Liverpool	31	1990-11-11	416	35
André Schürrle	0	Midfielder	Fulham	31	1990-11-06	417	24
John Stones	0	Defender	Manchester City	28	1994-05-28	418	24
David de Gea	0	Goalkeeper	Manchester United	31	1990-11-07	419	38

Best Defender

A defenders main job is in its name they are the front line between the strikers and the goalie so they must do all in their power to make sure the ball does not get past them. If they are able to do this they can get a clean sheet meaning no balls get scored on them.

Defend <- filter(df, rank_in_league_top_defenders != -1) %>% 
  select(c('full_name','clean_sheets_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_defenders', 'appearances_overall' )) 

DefendClean <- Defend[order(Defend$rank_in_league_top_defenders),]

kable(DefendClean, format = "html" , caption = "Top league Defenders",align = "cccccccccccccccc") %>% kable_styling()

Top league Defenders
full_name	clean_sheets_overall	position	current_club	age	birthday_gmt	rank_in_league_top_defenders	appearances_overall
Joe Gomez	11	Defender	Liverpool	25	1997-05-23	1	16
Andrew Robertson	21	Defender	Liverpool	28	1994-03-11	2	36
Alisson Becker	21	Goalkeeper	Liverpool	30	1992-10-02	3	38
Nicolas Otamendi	10	Defender	Manchester City	34	1988-02-12	4	18
Virgil van Dijk	21	Defender	Liverpool	31	1991-07-08	5	38
Trent Alexander-Arnold	16	Defender	Liverpool	24	1998-10-07	6	29
Vincent Kompany	7	Defender	Manchester City	36	1986-04-10	7	17
Joel Matip	11	Defender	Liverpool	31	1991-08-08	8	22
Phil Jagielka	5	Defender	Everton	40	1982-08-17	9	7
Kyle Walker	18	Defender	Manchester City	32	1990-05-28	10	33
Danny Rose	10	Defender	Tottenham Hotspur	32	1990-07-02	11	26
Benjamin Mendy	4	Defender	Manchester City	28	1994-07-17	12	10
Ederson	20	Goalkeeper	Manchester City	29	1993-08-17	13	38
Aymeric Laporte	18	Defender	Manchester City	28	1994-05-27	14	35
Dejan Lovren	6	Defender	Liverpool	33	1989-07-05	15	13
Caglar Söyüncü	2	Defender	Leicester City	26	1996-05-23	16	6
John Stones	13	Defender	Manchester City	28	1994-05-28	17	24
Danilo	5	Defender	Manchester City	31	1991-07-15	18	11
Kieran Trippier	10	Defender	Tottenham Hotspur	32	1990-09-19	19	27
Toby Alderweireld	12	Defender	Tottenham Hotspur	33	1989-03-02	20	34
Hugo Lloris	12	Goalkeeper	Tottenham Hotspur	35	1986-12-26	21	33
Marcos Alonso	14	Defender	Chelsea	31	1990-12-28	22	31
Fabian Schär	8	Defender	Newcastle United	30	1991-12-20	23	24
Scott Dann	3	Defender	Crystal Palace	35	1987-02-14	24	10
Kyle Walker-Peters	3	Defender	Tottenham Hotspur	25	1997-04-13	25	6
Davinson Sánchez Mina	6	Defender	Tottenham Hotspur	26	1996-06-12	26	23
David Luiz	16	Defender	Chelsea	35	1987-04-22	27	36
Juan Marcos Foyth	4	Defender	Tottenham Hotspur	24	1998-01-12	28	12
Antonio Valencia	2	Defender	Manchester United	37	1985-08-04	29	6
Javier Manquillo Gaitán	6	Defender	Newcastle United	28	1994-05-05	30	18
Jan Vertonghen	7	Defender	Tottenham Hotspur	35	1987-04-24	31	22
Jonny Evans	8	Defender	Leicester City	34	1988-01-03	32	24
Cesar Azpilicueta	16	Defender	Chelsea	33	1989-08-28	33	38
Séamus Coleman	13	Defender	Everton	34	1988-10-11	34	29
Andreas Christensen	3	Defender	Chelsea	26	1996-04-10	35	8
Florian Lejeune	3	Defender	Newcastle United	31	1991-05-20	36	12
Nacho Monreal	6	Defender	Arsenal	36	1986-02-26	37	22
Antonio Rüdiger	12	Defender	Chelsea	29	1993-03-03	38	33
Kepa Arrizabalaga	14	Goalkeeper	Chelsea	28	1994-10-03	39	36
Ryan Bennett	9	Defender	Wolverhampton Wanderers	32	1990-03-06	40	34
Jamal Lascelles	11	Defender	Newcastle United	28	1993-11-11	41	32
Lucas Digne	14	Defender	Everton	29	1993-07-20	42	35
Willy Boly	8	Defender	Wolverhampton Wanderers	31	1991-02-03	43	36
Ben Chilwell	10	Defender	Leicester City	25	1996-12-21	44	36
Vicente Guaita	7	Goalkeeper	Crystal Palace	35	1987-01-10	45	20
Matt Doherty	9	Defender	Wolverhampton Wanderers	30	1992-01-16	46	38
Rob Holding	2	Defender	Arsenal	27	1995-09-20	47	10
Wes Morgan	6	Defender	Leicester City	38	1984-01-21	48	22
Michael Keane	13	Defender	Everton	29	1993-01-11	49	33
Kasper Schmeichel	10	Goalkeeper	Leicester City	35	1986-11-05	50	38
Phil Jones	4	Defender	Manchester United	30	1992-02-21	51	18
Ricardo Domingos Barbosa Pereira	10	Defender	Leicester City	29	1993-10-06	52	35
Patrick van Aanholt	12	Defender	Crystal Palace	32	1990-08-29	53	36
Rúben Gonçalo Silva Nascimento Vinagre	5	Defender	Wolverhampton Wanderers	23	1999-04-09	54	17
Issa Diop	7	Defender	West Ham United	25	1997-01-09	55	33
Rui Pedro dos Santos Patrício	8	Goalkeeper	Wolverhampton Wanderers	34	1988-02-15	56	37
Jordan Pickford	14	Goalkeeper	Everton	28	1994-03-07	57	38
Martin Dúbravka	11	Goalkeeper	Newcastle United	33	1989-01-15	58	38
Jonny	8	Defender	Wolverhampton Wanderers	28	1994-03-03	59	33
Ben Davies	10	Defender	Tottenham Hotspur	29	1993-04-24	60	27
Hector Bellerin	4	Defender	Arsenal	27	1995-03-19	61	19
Phil Bardsley	4	Defender	Burnley	37	1985-06-28	62	19
James Tomkins	10	Defender	Crystal Palace	33	1989-03-29	63	29
Mamadou Sakho	9	Defender	Crystal Palace	32	1990-02-13	64	27
Jannik Vestergaard	4	Defender	Southampton	30	1992-08-03	65	23
Fabián Cornelio Balbuena González	5	Defender	West Ham United	31	1991-08-23	66	23
Yerry Fernando Mina González	4	Defender	Everton	28	1994-09-23	67	13
Tom Heaton	4	Goalkeeper	Burnley	36	1986-04-15	68	19
Paul Dummett	9	Defender	Newcastle United	31	1991-09-26	69	26
Kevin Long	1	Defender	Burnley	32	1990-08-18	70	6
Petr Čech	2	Goalkeeper	Arsenal	40	1982-05-20	71	7
Lee Peltier	6	Defender	Cardiff City	35	1986-12-11	72	20
Danny Simpson	3	Defender	Leicester City	35	1987-01-04	73	6
Shkodran Mustafi	6	Defender	Arsenal	30	1992-04-17	74	31
Sead Kolašinac	5	Defender	Arsenal	29	1993-06-20	75	24
Bernd Leno	7	Goalkeeper	Arsenal	30	1992-03-04	76	32
Luke Shaw	6	Defender	Manchester United	27	1995-07-12	77	29
Harry Maguire	7	Defender	Leicester City	29	1993-03-05	78	31
David Button	1	Goalkeeper	Brighton & Hove Albion	33	1989-02-27	79	4
Aaron Cresswell	3	Defender	West Ham United	32	1989-12-15	80	20
Łukasz Fabiański	7	Goalkeeper	West Ham United	37	1985-04-18	81	38
Sokratis Papastathopoulos	6	Defender	Arsenal	34	1988-06-09	82	25
Kurt Zouma	11	Defender	Everton	28	1994-10-27	83	32
Daryl Janmaat	3	Defender	Watford	33	1989-07-22	84	18
Adam Smith	9	Defender	AFC Bournemouth	31	1991-04-29	85	25
Jeffrey Schlupp	8	Defender	Crystal Palace	29	1992-12-23	86	30
Wayne Hennessey	5	Goalkeeper	Crystal Palace	35	1987-01-24	87	18
Victor Nilsson Lindelöf	6	Defender	Manchester United	28	1994-07-17	88	30
Arthur Masuaku	6	Defender	West Ham United	28	1993-11-07	89	23
Federico Fernández	4	Defender	Newcastle United	33	1989-02-21	90	19
David de Gea	7	Goalkeeper	Manchester United	31	1990-11-07	91	38
Bruno Saltor Grau	4	Defender	Brighton & Hove Albion	42	1980-10-01	92	14
DeAndre Yedlin	6	Defender	Newcastle United	29	1993-07-09	93	29
Adrian Mariappa	6	Defender	Watford	36	1986-10-03	94	26
Yann Valery	3	Defender	Southampton	23	1999-02-22	95	23
Emerson Palmieri dos Santos	3	Defender	Chelsea	28	1994-08-03	96	10
Leon Balogun	0	Defender	Brighton & Hove Albion	34	1988-06-28	97	8
Jan Bednarek	3	Defender	Southampton	26	1996-04-12	98	25
Pablo Zabaleta	4	Defender	West Ham United	37	1985-01-16	99	26
Artur Boruc	4	Goalkeeper	AFC Bournemouth	42	1980-02-20	100	12
Christian Kabasele	4	Defender	Watford	31	1991-02-24	101	21
Matteo Darmian	1	Defender	Manchester United	32	1989-12-02	102	6
Laurent Koscielny	4	Defender	Arsenal	37	1985-09-10	103	17
Angus Gunn	3	Goalkeeper	Southampton	26	1996-01-22	104	12
José Holebas	5	Defender	Watford	38	1984-06-27	105	28
Chris Smalling	4	Defender	Manchester United	32	1989-11-22	106	24
Bernardo	4	Defender	Brighton & Hove Albion	27	1995-05-14	107	22
Serge Aurier	3	Defender	Tottenham Hotspur	29	1992-12-24	108	8
Leighton Baines	1	Defender	Everton	37	1984-12-11	109	6
Martin Kelly	3	Defender	Crystal Palace	32	1990-04-27	110	13
Charlie Taylor	8	Defender	Burnley	29	1993-09-18	111	38
Joe Bennett	9	Defender	Cardiff City	32	1990-03-28	112	30
Ciaran Clark	2	Defender	Newcastle United	33	1989-09-26	113	11
Alex McCarthy	4	Goalkeeper	Southampton	32	1989-12-03	114	25
Shane Duffy	7	Defender	Brighton & Hove Albion	30	1992-01-01	115	35
Ben Foster	7	Goalkeeper	Watford	39	1983-04-03	116	38
Ryan Bertrand	6	Defender	Southampton	33	1989-08-05	117	24
Ben Mee	8	Defender	Burnley	33	1989-09-21	118	38
Craig Cathcart	6	Defender	Watford	33	1989-02-06	119	36
Lewis Dunk	7	Defender	Brighton & Hove Albion	30	1991-11-21	120	36
James Tarkowski	7	Defender	Burnley	29	1992-11-19	121	35
Mathew Ryan	6	Goalkeeper	Brighton & Hove Albion	30	1992-04-08	122	34
Wesley Hoedt	4	Defender	Southampton	28	1994-03-06	123	13
Angelo Ogbonna	3	Defender	West Ham United	34	1988-05-23	124	24
Mathias Jattah-Njie Jørgensen	3	Defender	Huddersfield Town	32	1990-04-23	125	24
Bruno Écuélé Manga	10	Defender	Cardiff City	34	1988-07-16	126	38
Cedric Soares	5	Defender	Southampton	31	1991-08-31	127	18
Martín Montoya	3	Defender	Brighton & Hove Albion	31	1991-04-14	128	25
Jonjoe Kenny	2	Defender	Everton	25	1997-03-15	129	10
Jack Stephens	5	Defender	Southampton	28	1994-01-27	130	24
José Diogo Dalot Teixeira	2	Defender	Manchester United	23	1999-03-18	131	16
Gaëtan Bong Songo	5	Defender	Brighton & Hove Albion	34	1988-04-25	132	22
Maya Yoshida	3	Defender	Southampton	34	1988-08-24	133	17
Neil Leonard Dula Etheridge	10	Goalkeeper	Cardiff City	32	1990-02-07	134	38
Florent Hadergjonaj	4	Defender	Huddersfield Town	28	1994-07-31	135	24
Souleymane Bamba	7	Defender	Cardiff City	37	1985-01-13	136	28
Callum Paterson	7	Defender	Cardiff City	28	1994-10-13	137	27
Simon Francis	5	Defender	AFC Bournemouth	37	1985-02-16	138	17
Jonas Lössl	5	Goalkeeper	Huddersfield Town	33	1989-02-01	139	31
Sean Morrison	9	Defender	Cardiff City	31	1991-01-08	140	34
Eric Bertrand Bailly	3	Defender	Manchester United	28	1994-04-12	141	12
Chris Mepham	3	Defender	AFC Bournemouth	24	1997-11-05	142	13
Calum Chambers	5	Defender	Fulham	27	1995-01-20	143	31
Adam Masina	2	Defender	Watford	28	1994-01-02	144	14
Steve Cook	9	Defender	AFC Bournemouth	31	1991-04-19	145	31
Nathaniel Clyne	6	Defender	AFC Bournemouth	31	1991-04-05	146	18
Stephan Lichtsteiner	2	Defender	Arsenal	38	1984-01-16	147	14
Nathan Aké	10	Defender	AFC Bournemouth	27	1995-02-18	148	38
Joe Hart	4	Goalkeeper	Burnley	35	1987-04-19	149	19
Matthew Lowton	4	Defender	Burnley	33	1989-06-09	150	21
Matt Targett	1	Defender	Southampton	27	1995-09-18	151	16
Charlie Daniels	6	Defender	AFC Bournemouth	36	1986-09-07	152	21
Sergio Rico	5	Goalkeeper	Fulham	29	1993-09-01	153	29
Asmir Begović	5	Goalkeeper	AFC Bournemouth	35	1987-06-20	154	24
Cyrus Christie	5	Defender	Fulham	30	1992-09-30	155	28
Erik Durm	3	Defender	Huddersfield Town	30	1992-05-12	156	28
Christopher Schindler	5	Defender	Huddersfield Town	32	1990-04-29	157	37
Joe Bryan	5	Defender	Fulham	29	1993-09-17	158	28
Joel Ward	0	Defender	Crystal Palace	32	1989-10-29	159	7
Mason Holgate	0	Defender	Everton	26	1996-10-22	160	5
Alfie Mawson	3	Defender	Fulham	28	1994-01-19	161	15
Maxime Le Marchand	4	Defender	Fulham	33	1989-10-11	162	26
Jack Simpson	2	Defender	AFC Bournemouth	25	1996-12-18	163	6
Timothy Fosu-Mensah	1	Defender	Fulham	24	1998-01-02	164	12
Terence Kongolo	4	Defender	Huddersfield Town	28	1994-02-14	165	32
Denis Odoi	5	Defender	Fulham	34	1988-05-27	166	31
Tim Ream	5	Defender	Fulham	35	1987-10-05	167	26
Ryan Sessegnon	4	Defender	Fulham	22	2000-05-18	168	35
Chris Löwe	1	Defender	Huddersfield Town	33	1989-04-16	169	29
Greg Cunningham	1	Defender	Cardiff City	31	1991-01-31	170	7
Jon Gorenc Stankovič	2	Defender	Huddersfield Town	26	1996-01-14	171	11
Diego Rico	0	Defender	AFC Bournemouth	29	1993-02-23	172	12
Tom Smith	1	Defender	Huddersfield Town	30	1992-04-14	173	15
Marcus Bettinelli	0	Goalkeeper	Fulham	30	1992-05-24	174	7
Ben Hamer	1	Goalkeeper	Huddersfield Town	34	1987-11-20	175	7

Best Scorer

A Scorer can be anyone as long as they shoot their shot and get it in they rank. These rankings in this section specifically focus on who is the best in their respective club (team).

Scorer <- filter(df, rank_in_club_top_scorer != -1) %>% 
  select(c('full_name','goals_overall','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_club_top_scorer', 'appearances_overall' )) 

ScorerClean <- Scorer[order(Scorer$rank_in_club_top_scorer,-Scorer$goals_overall),]

kable(ScorerClean, format = "html" , caption = "Top league Scorer",align = "cccccccccccccccc") %>% kable_styling()

Top league Scorer
full_name	goals_overall	assists_overall	position	current_club	age	birthday_gmt	rank_in_club_top_scorer	appearances_overall
Pierre-Emerick Aubameyang	22	5	Forward	Arsenal	33	1989-06-18	1	36
Sadio Mané	22	1	Forward	Liverpool	30	1992-04-10	1	36
Sergio Aguero	21	8	Forward	Manchester City	34	1988-06-02	1	33
Jamie Vardy	18	4	Forward	Leicester City	35	1987-01-11	1	34
Harry Kane	17	4	Forward	Tottenham Hotspur	29	1993-07-28	1	28
Eden Hazard	16	15	Midfielder	Chelsea	31	1991-01-07	1	37
Callum Wilson	14	9	Forward	AFC Bournemouth	30	1992-02-27	1	30
Glenn Murray	13	1	Forward	Brighton & Hove Albion	39	1983-09-25	1	38
Paul Pogba	13	9	Midfielder	Manchester United	29	1993-03-15	1	35
Raúl Alonso Jiménez Rodríguez	13	7	Forward	Wolverhampton Wanderers	31	1991-05-05	1	38
Richarlison de Andrade	13	1	Forward	Everton	25	1997-05-10	1	35
Ashley Barnes	12	2	Forward	Burnley	32	1989-10-30	1	37
Ayoze Perez	12	2	Forward	Newcastle United	29	1993-07-29	1	37
Luka Milivojević	12	2	Midfielder	Crystal Palace	31	1991-04-07	1	38
Aleksandar Mitrović	11	3	Forward	Fulham	28	1994-09-16	1	37
Gerard Deulofeu	10	5	Forward	Watford	28	1994-03-13	1	30
Marko Arnautović	10	4	Forward	West Ham United	33	1989-04-19	1	28
James Ward-Prowse	7	0	Midfielder	Southampton	27	1994-11-01	1	26
Víctor Camarasa	5	4	Midfielder	Cardiff City	28	1994-05-28	1	32
Karlan Ahearne-Grant	4	0	Forward	Huddersfield Town	24	1997-12-19	1	13
Mohamed Salah	22	8	Forward	Liverpool	30	1992-06-15	2	38
Raheem Sterling	17	10	Forward	Manchester City	27	1994-12-08	2	34
Alexandre Lacazette	13	8	Forward	Arsenal	31	1991-05-28	2	35
Gylfi Sigurdsson	13	6	Midfielder	Everton	33	1989-09-08	2	38
Heung-Min Son	12	6	Forward	Tottenham Hotspur	30	1992-07-08	2	31
Joshua King	12	3	Forward	AFC Bournemouth	30	1992-01-15	2	35
Romelu Lukaku	12	0	Forward	Manchester United	29	1993-05-13	2	32
Rondon	11	7	Forward	Newcastle United	33	1989-09-16	2	32
Chris Wood	10	2	Forward	Burnley	30	1991-12-07	2	38
Wilfried Zaha	10	5	Midfielder	Crystal Palace	29	1992-11-10	2	34
Diogo José Teixeira da Silva	9	5	Midfielder	Wolverhampton Wanderers	25	1996-12-04	2	33
Felipe Anderson Pereira Gomes	9	4	Midfielder	West Ham United	29	1993-04-15	2	36
Troy Deeney	9	5	Forward	Watford	34	1988-06-29	2	32
Pedro Rodriguez	8	2	Midfielder	Chelsea	35	1987-07-28	2	31
Daniel William John Ings	7	3	Forward	Southampton	30	1992-07-23	2	24
James Maddison	7	7	Midfielder	Leicester City	25	1996-11-23	2	36
André Schürrle	6	0	Midfielder	Fulham	31	1990-11-06	2	24
Bobby Reid	5	2	Midfielder	Cardiff City	29	1993-02-02	2	27
Shane Duffy	5	1	Defender	Brighton & Hove Albion	30	1992-01-01	2	35
Mathias Jattah-Njie Jørgensen	3	1	Defender	Huddersfield Town	32	1990-04-23	2	24
Roberto Firmino	12	6	Forward	Liverpool	31	1991-10-02	3	34
Leroy Sané	10	10	Midfielder	Manchester City	26	1996-01-11	3	31
Lucas Rodrigues Moura da Silva	10	0	Midfielder	Tottenham Hotspur	30	1992-08-13	3	32
Marcus Rashford	10	6	Forward	Manchester United	25	1997-10-31	3	33
Andre Gray	7	2	Forward	Watford	31	1991-06-26	3	29
Javier Hernandez	7	1	Forward	West Ham United	34	1988-06-01	3	25
Ryan Fraser	7	14	Midfielder	AFC Bournemouth	28	1994-02-24	3	38
Andros Townsend	6	4	Midfielder	Crystal Palace	31	1991-07-16	3	38
Dominic Calvert-Lewin	6	2	Forward	Everton	25	1997-03-16	3	35
Henrikh Mkhitaryan	6	4	Midfielder	Arsenal	33	1989-01-21	3	25
Nathan Redmond	6	4	Midfielder	Southampton	28	1994-03-06	3	38
Ruben Loftus-Cheek	6	2	Midfielder	Chelsea	26	1996-01-23	3	24
Ryan Guno Babel	5	3	Forward	Fulham	35	1986-12-19	3	16
Callum Paterson	4	1	Defender	Cardiff City	28	1994-10-13	3	27
Demarai Gray	4	1	Midfielder	Leicester City	26	1996-06-28	3	34
Fabian Schär	4	1	Defender	Newcastle United	30	1991-12-20	3	24
Rúben Diogo Da Silva Neves	4	3	Midfielder	Wolverhampton Wanderers	25	1997-03-13	3	35
Aaron Mooy	3	1	Midfielder	Huddersfield Town	32	1990-09-15	3	29
Florin Andone	3	0	Forward	Brighton & Hove Albion	29	1993-04-11	3	23
Sam Vokes	3	0	Forward	Burnley	33	1989-10-21	3	20
Anthony Martial	10	2	Forward	Manchester United	26	1995-12-05	4	27
Christian Eriksen	8	12	Midfielder	Tottenham Hotspur	30	1992-02-14	4	35
David Brooks	7	5	Forward	AFC Bournemouth	25	1997-07-08	4	30
Gabriel Jesus	7	3	Forward	Manchester City	25	1997-04-03	4	29
Michail Antonio	6	4	Midfielder	West Ham United	32	1990-03-28	4	33
Roberto Maximiliano Pereyra	6	1	Forward	Watford	31	1991-01-07	4	33
Xherdan Shaqiri	6	3	Midfielder	Liverpool	31	1991-10-10	4	24
Alvaro Morata	5	0	Forward	Chelsea	30	1992-10-23	4	16
Mesut Özil	5	2	Midfielder	Arsenal	34	1988-10-15	4	24
Michy Batshuayi	5	0	Forward	Crystal Palace	29	1993-10-02	4	11
Shane Long	5	1	Forward	Southampton	35	1987-01-22	4	26
Theo Walcott	5	2	Forward	Everton	33	1989-03-16	4	37
Souleymane Bamba	4	1	Defender	Cardiff City	37	1985-01-13	4	28
Willy Boly	4	0	Defender	Wolverhampton Wanderers	31	1991-02-03	4	36
Aboubakar Kamara	3	0	Forward	Fulham	27	1995-03-07	4	13
Ciaran Clark	3	0	Defender	Newcastle United	33	1989-09-26	4	11
James Tarkowski	3	1	Defender	Burnley	29	1992-11-19	4	35
Pascal Groß	3	3	Midfielder	Brighton & Hove Albion	31	1991-06-15	4	25
Youri Tielemans	3	4	Midfielder	Leicester City	25	1997-05-07	4	13
Philip Billing	2	0	Midfielder	Huddersfield Town	26	1996-06-11	4	27
Bernardo Silva	7	7	Midfielder	Manchester City	28	1994-08-10	5	36
Abdoulaye Doucouré	5	6	Midfielder	Watford	29	1993-01-01	5	35
Dele Alli	5	3	Midfielder	Tottenham Hotspur	26	1996-04-11	5	25
Gonzalo Higuain	5	0	Forward	Chelsea	34	1987-12-10	5	14
James Milner	5	4	Midfielder	Liverpool	36	1986-01-04	5	31
Mark Noble	5	5	Midfielder	West Ham United	35	1987-05-08	5	31
Aaron Ramsey	4	6	Midfielder	Arsenal	31	1990-12-26	5	28
Jeffrey Schlupp	4	1	Defender	Crystal Palace	29	1992-12-23	5	30
Jesse Lingard	4	2	Midfielder	Manchester United	29	1992-12-15	5	27
Lucas Digne	4	4	Defender	Everton	29	1993-07-20	5	35
Matt Doherty	4	5	Defender	Wolverhampton Wanderers	30	1992-01-16	5	38
Nathan Aké	4	0	Defender	AFC Bournemouth	27	1995-02-18	5	38
Nathaniel Mendez-Laing	4	1	Midfielder	Cardiff City	30	1992-04-15	5	20
Pierre-Emile Højbjerg	4	3	Midfielder	Southampton	27	1995-08-05	5	31
Harry Maguire	3	0	Defender	Leicester City	29	1993-03-05	5	31
Johann Berg Guðmundsson	3	6	Midfielder	Burnley	32	1990-10-27	5	29
Alex Pritchard	2	0	Midfielder	Huddersfield Town	29	1993-05-03	5	30
Calum Chambers	2	0	Defender	Fulham	27	1995-01-20	5	31
José Luis Sanmartín Mato	2	0	Forward	Newcastle United	32	1990-03-27	5	16
Lewis Dunk	2	1	Defender	Brighton & Hove Albion	30	1991-11-21	5	36
Riyad Mahrez	7	4	Midfielder	Manchester City	31	1991-02-21	6	27
Erik Lamela	4	2	Midfielder	Tottenham Hotspur	30	1992-03-04	6	19
Granit Xhaka	4	2	Midfielder	Arsenal	30	1992-09-27	6	29
N’Golo Kanté	4	4	Midfielder	Chelsea	31	1991-03-29	6	36
Virgil van Dijk	4	2	Defender	Liverpool	31	1991-07-08	6	38
Cenk Tosun	3	3	Forward	Everton	31	1991-06-07	6	25
Craig Cathcart	3	0	Defender	Watford	33	1989-02-06	6	36
Ivan Ricardo Neves Abreu Cavaleiro	3	1	Forward	Wolverhampton Wanderers	29	1993-10-18	6	23
Jeff Hendrick	3	0	Midfielder	Burnley	30	1992-01-31	6	32
Josh Murphy	3	2	Forward	Cardiff City	27	1995-02-24	6	29
Juan Mata	3	2	Midfielder	Manchester United	34	1988-04-28	6	22
Lucas Perez	3	0	Forward	West Ham United	34	1988-09-10	6	15
Patrick van Aanholt	3	2	Defender	Crystal Palace	32	1990-08-29	6	36
Stuart Armstrong	3	2	Midfielder	Southampton	30	1992-03-30	6	29
Wes Morgan	3	0	Defender	Leicester City	38	1984-01-21	6	22
Anthony Knockaert	2	6	Midfielder	Brighton & Hove Albion	30	1991-11-20	6	30
Jefferson Lerma	2	0	Midfielder	AFC Bournemouth	28	1994-10-25	6	30
Matt Ritchie	2	8	Midfielder	Newcastle United	33	1989-09-10	6	36
Ryan Sessegnon	2	6	Defender	Fulham	22	2000-05-18	6	35
Steve Mounié	2	3	Forward	Huddersfield Town	28	1994-09-29	6	31
David Silva	6	8	Midfielder	Manchester City	36	1986-01-08	7	33
David Junior Hoilett	3	1	Forward	Cardiff City	32	1990-06-05	7	32
Divock Origi	3	1	Forward	Liverpool	27	1995-04-18	7	12
Dwight McNeil	3	5	Forward	Burnley	22	1999-11-22	7	21
Eric Dier	3	0	Midfielder	Tottenham Hotspur	28	1994-01-15	7	20
James McArthur	3	6	Midfielder	Crystal Palace	35	1987-10-07	7	38
José Holebas	3	6	Defender	Watford	38	1984-06-27	7	28
Laurent Koscielny	3	0	Defender	Arsenal	37	1985-09-10	7	17
Ross Barkley	3	5	Midfielder	Chelsea	28	1993-12-05	7	27
Ander Herrera	2	3	Midfielder	Manchester United	33	1989-08-14	7	22
Andriy Yarmolenko	2	0	Forward	West Ham United	33	1989-10-23	7	9
Junior Stanislas	2	3	Midfielder	AFC Bournemouth	32	1989-11-26	7	23
Jürgen Locadia	2	0	Forward	Brighton & Hove Albion	28	1993-11-07	7	26
Kurt Zouma	2	2	Defender	Everton	28	1994-10-27	7	32
Ricardo Domingos Barbosa Pereira	2	6	Defender	Leicester City	29	1993-10-06	7	35
Romain Saïss	2	0	Midfielder	Wolverhampton Wanderers	32	1990-03-26	7	19
Yann Valery	2	1	Defender	Southampton	23	1999-02-22	7	23
Christian Atsu Twasam	1	0	Midfielder	Newcastle United	30	1992-01-10	7	28
Jean Michau00ebl Seri	1	2	Midfielder	Fulham	31	1991-07-19	7	32
Juninho Bacuna	1	0	Midfielder	Huddersfield Town	25	1997-08-07	7	21
İlkay Gündoğan	6	3	Midfielder	Manchester City	32	1990-10-24	8	31
Alex Iwobi	3	6	Forward	Arsenal	26	1996-05-03	8	35
Georginio Wijnaldum	3	0	Midfielder	Liverpool	31	1990-11-11	8	35
Willian	3	6	Forward	Chelsea	34	1988-08-09	8	32
Ashley Westwood	2	7	Midfielder	Burnley	32	1990-04-01	8	34
Charlie Austin	2	2	Forward	Southampton	33	1989-07-05	8	25
Dan Gosling	2	1	Midfielder	AFC Bournemouth	32	1990-02-01	8	25
Leander Dendoncker	2	0	Midfielder	Wolverhampton Wanderers	27	1995-04-15	8	19
Marc Albrighton	2	2	Midfielder	Leicester City	32	1989-11-18	8	27
Robert Snodgrass	2	5	Midfielder	West Ham United	35	1987-09-07	8	33
Scott McTominay	2	0	Midfielder	Manchester United	25	1996-12-08	8	16
Séamus Coleman	2	2	Defender	Everton	34	1988-10-11	8	29
Will Hughes	2	4	Midfielder	Watford	27	1995-04-17	8	32
Beram Kayal	1	1	Midfielder	Brighton & Hove Albion	34	1988-05-02	8	18
Fernando Llorente Torres	1	4	Forward	Tottenham Hotspur	37	1985-02-26	8	20
Jon Gorenc Stankovič	1	0	Defender	Huddersfield Town	26	1996-01-14	8	11
Luciano Vietto	1	4	Forward	Fulham	28	1993-12-05	8	20
Max Meyer	1	2	Midfielder	Crystal Palace	27	1995-09-18	8	29
Sean Morrison	1	3	Defender	Cardiff City	31	1991-01-08	8	34
Yoshinori Muto	1	0	Forward	Newcastle United	30	1992-07-15	8	17
Aymeric Laporte	3	3	Defender	Manchester City	28	1994-05-27	9	35
David Luiz	3	2	Defender	Chelsea	35	1987-04-22	9	36
Ashley Young	2	2	Midfielder	Manchester United	37	1985-07-09	9	30
Declan Rice	2	0	Midfielder	West Ham United	23	1999-01-14	9	34
Naby Deco Keïta	2	1	Midfielder	Liverpool	27	1995-02-10	9	25
Onyinye Wilfred Ndidi	2	0	Midfielder	Leicester City	25	1996-12-16	9	38
Shkodran Mustafi	2	0	Defender	Arsenal	30	1992-04-17	9	31
Aron Einar Gunnarsson	1	1	Midfielder	Cardiff City	33	1989-04-22	9	28
Ben Gibson	1	0	Defender	Burnley	29	1993-01-15	9	1
Christopher Schindler	1	0	Defender	Huddersfield Town	32	1990-04-29	9	37
Dale Stephens	1	1	Midfielder	Brighton & Hove Albion	33	1989-06-12	9	30
Etienne Capoue	1	3	Midfielder	Watford	34	1988-07-11	9	33
Floyd Ayité	1	0	Midfielder	Fulham	33	1988-12-15	9	16
Harry Winks	1	0	Midfielder	Tottenham Hotspur	26	1996-02-02	9	26
Hélder Wander Sousa Azevedo Costa	1	2	Midfielder	Wolverhampton Wanderers	28	1994-01-12	9	25
James Tomkins	1	1	Defender	Crystal Palace	33	1989-03-29	9	29
Oriol Romeu	1	0	Midfielder	Southampton	31	1991-09-24	9	31
Robert Kenedy Nunes do Nascimento	1	1	Midfielder	Newcastle United	26	1996-02-08	9	25
Steve Cook	1	1	Defender	AFC Bournemouth	31	1991-04-19	9	31
Yerry Fernando Mina González	1	0	Defender	Everton	28	1994-09-23	9	13
Daniel Sturridge	2	1	Forward	Liverpool	33	1989-09-01	10	18
Kevin De Bruyne	2	2	Midfielder	Manchester City	31	1991-06-28	10	19
Lucas Torreira	2	2	Midfielder	Arsenal	26	1996-02-11	10	34
Marcos Alonso	2	4	Defender	Chelsea	31	1990-12-28	10	31
Aaron Lennon	1	1	Midfielder	Burnley	35	1987-04-16	10	16
Adam Smith	1	1	Defender	AFC Bournemouth	31	1991-04-29	10	25
Alexis Sanchez	1	3	Forward	Manchester United	33	1988-12-19	10	20
Christian Benteke	1	1	Forward	Crystal Palace	31	1990-12-03	10	16
Danny Ward	1	0	Forward	Cardiff City	31	1990-12-09	10	14
Davy Pröpper	1	1	Midfielder	Brighton & Hove Albion	31	1991-09-02	10	30
Fabián Cornelio Balbuena González	1	0	Defender	West Ham United	31	1991-08-23	10	23
Harvey Lewis Barnes	1	2	Midfielder	Leicester City	24	1997-12-09	10	16
Isaac Ajayi Success	1	1	Forward	Watford	26	1996-01-07	10	30
Isaac Hayden	1	4	Midfielder	Newcastle United	27	1995-03-22	10	25
Jan Vertonghen	1	0	Defender	Tottenham Hotspur	35	1987-04-24	10	22
Mario Lemina	1	1	Midfielder	Southampton	29	1993-09-01	10	21
Michael Keane	1	2	Defender	Everton	29	1993-01-11	10	33
Ryan Bennett	1	0	Defender	Wolverhampton Wanderers	32	1990-03-06	10	34
Terence Kongolo	1	1	Defender	Huddersfield Town	28	1994-02-14	10	32
Tom Cairney	1	1	Midfielder	Fulham	31	1991-01-20	10	31
Jorginho	2	0	Midfielder	Chelsea	30	1991-12-20	11	37
André Filipe Tavares Gomes	1	1	Midfielder	Everton	29	1993-07-30	11	27
Isaac Mbenza	1	1	Forward	Huddersfield Town	26	1996-03-08	11	22
Jack Cork	1	2	Midfielder	Burnley	33	1989-06-25	11	37
João Moutinho	1	8	Midfielder	Wolverhampton Wanderers	36	1986-09-08	11	38
Joel Matip	1	0	Defender	Liverpool	31	1991-08-08	11	22
Joel Ward	1	0	Defender	Crystal Palace	32	1989-10-29	11	7
Jonny Evans	1	0	Defender	Leicester City	34	1988-01-03	11	24
Kadeem Harris	1	0	Midfielder	Cardiff City	29	1993-06-08	11	13
Lys Mousset	1	0	Forward	AFC Bournemouth	26	1996-02-08	11	24
Matt Targett	1	3	Defender	Southampton	27	1995-09-18	11	16
Nacho Monreal	1	3	Defender	Arsenal	36	1986-02-26	11	22
Nemanja Matić	1	0	Midfielder	Manchester United	34	1988-08-01	11	28
Philip Foden	1	0	Midfielder	Manchester City	22	2000-05-28	11	13
Ryan Fredericks	1	0	Midfielder	West Ham United	30	1992-10-10	11	15
Sean Longstaff	1	0	Midfielder	Newcastle United	25	1997-10-30	11	9
Solomon March	1	5	Midfielder	Brighton & Hove Albion	28	1994-07-20	11	35
Tom Cleverley	1	0	Midfielder	Watford	33	1989-08-12	11	13
Victor Wanyama	1	0	Midfielder	Tottenham Hotspur	31	1991-06-25	11	13
Alfie Mawson	0	0	Defender	Fulham	28	1994-01-19	11	15
Olivier Giroud	2	4	Forward	Chelsea	36	1986-09-30	12	27
Bernard Anício Caldeira Duarte	1	3	Midfielder	Everton	30	1992-09-08	12	34
Charlie Daniels	1	0	Defender	AFC Bournemouth	36	1986-09-07	12	21
Dejan Lovren	1	0	Defender	Liverpool	33	1989-07-05	12	13
Francisco Femenía Far	1	1	Midfielder	Watford	31	1991-02-02	12	29
Frederico Rodrigues Santos	1	1	Midfielder	Manchester United	29	1993-03-05	12	17
Jonjo Shelvey	1	1	Midfielder	Newcastle United	30	1992-02-27	12	16
Jonny	1	1	Defender	Wolverhampton Wanderers	28	1994-03-03	12	33
Jordan Ayew	1	2	Forward	Crystal Palace	31	1991-09-11	12	20
Kenneth Dahrup Zohorè	1	1	Forward	Cardiff City	28	1994-01-31	12	19
Kieran Trippier	1	3	Defender	Tottenham Hotspur	32	1990-09-19	12	27
Leon Balogun	1	0	Defender	Brighton & Hove Albion	34	1988-06-28	12	8
Manolo Gabbiadini	1	0	Forward	Southampton	30	1991-11-26	12	12
Manuel Lanzini	1	1	Midfielder	West Ham United	29	1993-02-15	12	10
Matěj Vydra	1	1	Forward	Burnley	30	1992-05-01	12	13
Rachid Ghezzal	1	0	Forward	Leicester City	30	1992-05-09	12	19
Sokratis Papastathopoulos	1	2	Defender	Arsenal	34	1988-06-09	12	25
Vincent Kompany	1	0	Defender	Manchester City	36	1986-04-10	12	17
Elias Kachunga	0	0	Forward	Huddersfield Town	30	1992-04-22	12	20
Tim Ream	0	0	Defender	Fulham	35	1987-10-05	12	26
Adama Traoré Diarra	1	1	Midfielder	Wolverhampton Wanderers	26	1996-01-25	13	29
Angelo Ogbonna	1	1	Defender	West Ham United	34	1988-05-23	13	24
Antonio Rüdiger	1	0	Defender	Chelsea	29	1993-03-03	13	33
Danilo	1	0	Defender	Manchester City	31	1991-07-15	13	11
Danny Welbeck	1	1	Forward	Arsenal	31	1990-11-26	13	8
Davinson Sánchez Mina	1	1	Defender	Tottenham Hotspur	26	1996-06-12	13	23
DeAndre Yedlin	1	2	Defender	Newcastle United	29	1993-07-09	13	29
Domingos Quina	1	0	Midfielder	Watford	22	1999-11-18	13	8
Jordon Ibe	1	1	Midfielder	AFC Bournemouth	26	1995-12-08	13	19
Kelechi Iheanacho	1	3	Forward	Leicester City	26	1996-10-03	13	30
Luke Shaw	1	4	Defender	Manchester United	27	1995-07-12	13	29
Phil Jagielka	1	0	Defender	Everton	40	1982-08-17	13	7
Ryan Bertrand	1	0	Defender	Southampton	33	1989-08-05	13	24
Trent Alexander-Arnold	1	12	Defender	Liverpool	24	1998-10-07	13	29
Erik Durm	0	1	Defender	Huddersfield Town	30	1992-05-12	13	28
Fabricio Martín Agosto Ramírez	0	0	Goalkeeper	Fulham	34	1987-12-31	13	2
Martín Montoya	0	1	Defender	Brighton & Hove Albion	31	1991-04-14	13	25
Oumar Niasse	0	0	Forward	Cardiff City	32	1990-04-18	13	18
Robbie Brady	0	1	Midfielder	Burnley	30	1992-01-14	13	16
Wayne Hennessey	0	0	Goalkeeper	Crystal Palace	35	1987-01-24	13	18
Cesar Azpilicueta	1	5	Defender	Chelsea	33	1989-08-28	14	38
Edward Nketiah	1	0	Forward	Arsenal	23	1999-05-30	14	5
Issa Diop	1	0	Defender	West Ham United	25	1997-01-09	14	33
Jack Stephens	1	0	Defender	Southampton	28	1994-01-27	14	24
Jordan Henderson	1	3	Midfielder	Liverpool	32	1990-06-17	14	32
Juan Marcos Foyth	1	0	Defender	Tottenham Hotspur	24	1998-01-12	14	12
Ken Sema	1	2	Midfielder	Watford	29	1993-09-30	14	17
Kyle Walker	1	1	Defender	Manchester City	32	1990-05-28	14	33
Victor Nilsson Lindelöf	1	1	Defender	Manchester United	28	1994-07-17	14	30
Ben Hamer	0	0	Goalkeeper	Huddersfield Town	34	1987-11-20	14	7
David Button	0	0	Goalkeeper	Brighton & Hove Albion	33	1989-02-27	14	4
Emerson Hyndman	0	0	Midfielder	AFC Bournemouth	26	1996-04-09	14	1
Florian Lejeune	0	0	Defender	Newcastle United	31	1991-05-20	14	12
Jordan Pickford	0	0	Goalkeeper	Everton	28	1994-03-07	14	38
Leonardo Bonatini Lohner Maia	0	1	Forward	Wolverhampton Wanderers	28	1994-03-28	14	7
Marcus Bettinelli	0	0	Goalkeeper	Fulham	30	1992-05-24	14	7
Rhys Healey	0	0	Forward	Cardiff City	27	1994-12-06	14	3
Scott Dann	0	1	Defender	Crystal Palace	35	1987-02-14	14	10
Steven Defour	0	0	Midfielder	Burnley	34	1988-04-15	14	6
Vicente Iborra De La Fuente	0	0	Midfielder	Leicester City	34	1988-01-16	14	8
Ainsley Maitland-Niles	1	1	Midfielder	Arsenal	25	1997-08-29	15	16
Cedric Soares	1	2	Defender	Southampton	31	1991-08-31	15	18
Chris Smalling	1	0	Defender	Manchester United	32	1989-11-22	15	24
Fabinho	1	2	Midfielder	Liverpool	29	1993-10-23	15	28
Fernando Luiz Rosa	1	3	Midfielder	Manchester City	37	1985-05-04	15	29
Adrien Sebastian Perruchet Silva	0	0	Midfielder	Leicester City	33	1989-03-15	15	2
Collin Quaner	0	0	Forward	Huddersfield Town	31	1991-06-18	15	2
Federico Fernández	0	1	Defender	Newcastle United	33	1989-02-21	15	19
Gary Cahill	0	0	Defender	Chelsea	36	1985-12-19	15	2
Håvard Nordtveit	0	1	Midfielder	Fulham	32	1990-06-21	15	5
Jonjoe Kenny	0	1	Defender	Everton	25	1997-03-15	15	10
Julián Speroni	0	0	Goalkeeper	Crystal Palace	43	1979-05-18	15	1
Kevin Long	0	1	Defender	Burnley	32	1990-08-18	15	6
Loïc Damour	0	0	Midfielder	Cardiff City	31	1991-01-08	15	2
Marc Navarro Ceciliano	0	0	Defender	Watford	27	1995-07-02	15	2
Mathew Ryan	0	0	Goalkeeper	Brighton & Hove Albion	30	1992-04-08	15	34
Paulo Dino Gazzaniga	0	0	Goalkeeper	Tottenham Hotspur	30	1992-01-02	15	3
Rúben Gonçalo Silva Nascimento Vinagre	0	0	Defender	Wolverhampton Wanderers	23	1999-04-09	15	17
Sam Surridge	0	0	Forward	AFC Bournemouth	24	1998-07-28	15	2
Samir Nasri	0	2	Midfielder	West Ham United	35	1987-06-26	15	5
Andreas Pereira	1	1	Midfielder	Manchester United	26	1996-01-01	16	15
Michael Obafemi	1	1	Forward	Southampton	22	2000-07-06	16	6
Alexandre Nascimento Costa Silva	0	0	Forward	West Ham United	25	1997-03-16	16	1
Alireza Jahanbakhsh	0	0	Forward	Brighton & Hove Albion	29	1993-08-11	16	19
Alisson Becker	0	0	Goalkeeper	Liverpool	30	1992-10-02	16	38
Antonio Barreca	0	0	Defender	Newcastle United	27	1995-03-18	16	1
Ben Chilwell	0	4	Defender	Leicester City	25	1996-12-21	16	36
Callum Hudson-Odoi	0	1	Midfielder	Chelsea	21	2000-11-07	16	10
Connor Wickham	0	1	Forward	Crystal Palace	29	1993-03-31	16	6
Dominic Solanke	0	1	Forward	AFC Bournemouth	25	1997-09-14	16	10
Harry Arter	0	1	Midfielder	Cardiff City	32	1989-12-28	16	25
Joe Hart	0	0	Goalkeeper	Burnley	35	1987-04-19	16	19
Joel Coleman	0	0	Goalkeeper	Huddersfield Town	27	1995-09-26	16	1
Joseph Willock	0	0	Midfielder	Arsenal	23	1999-08-20	16	2
Lazar Marković	0	0	Midfielder	Fulham	28	1994-03-02	16	1
Mason Holgate	0	0	Defender	Everton	26	1996-10-22	16	5
Morgan Gibbs-White	0	1	Midfielder	Wolverhampton Wanderers	22	2000-01-27	16	26
Nicolas Otamendi	0	0	Defender	Manchester City	34	1988-02-12	16	18
Oliver Skipp	0	0	Midfielder	Tottenham Hotspur	22	2000-09-16	16	8
Stefano Okaka	0	0	Forward	Watford	33	1989-08-09	16	2
Ademola Lookman	0	2	Forward	Everton	25	1997-10-20	17	21
Alberto Moreno	0	0	Defender	Liverpool	30	1992-07-05	17	2
Alexander Sørloth	0	0	Forward	Crystal Palace	26	1995-12-05	17	12
Andy Carroll	0	0	Forward	West Ham United	33	1989-01-06	17	12
Ben Wilmot	0	0	Defender	Watford	23	1999-11-04	17	2
Chris Mepham	0	1	Defender	AFC Bournemouth	24	1997-11-05	17	13
Christian Fuchs	0	0	Defender	Leicester City	36	1986-04-07	17	3
Danny Rose	0	3	Defender	Tottenham Hotspur	32	1990-07-02	17	26
Demeaco Duhaney	0	0	Defender	Huddersfield Town	24	1998-10-13	17	1
Denis Odoi	0	1	Defender	Fulham	34	1988-05-27	17	31
Emerson Palmieri dos Santos	0	0	Defender	Chelsea	28	1994-08-03	17	10
Jacob Murphy	0	1	Midfielder	Newcastle United	27	1995-02-24	17	9
John Ruddy	0	0	Goalkeeper	Wolverhampton Wanderers	36	1986-10-24	17	1
John Stones	0	0	Defender	Manchester City	28	1994-05-28	17	24
José Diogo Dalot Teixeira	0	2	Defender	Manchester United	23	1999-03-18	17	16
Neil Leonard Dula Etheridge	0	0	Goalkeeper	Cardiff City	32	1990-02-07	17	38
Phil Bardsley	0	0	Defender	Burnley	37	1985-06-28	17	19
Sam Gallagher	0	0	Forward	Southampton	27	1995-09-15	17	4
Yves Bissouma	0	0	Midfielder	Brighton & Hove Albion	26	1996-08-30	17	28
Adam David Lallana	0	0	Midfielder	Liverpool	34	1988-05-10	18	13
Ben Foster	0	0	Goalkeeper	Watford	39	1983-04-03	18	38
Benjamin Mendy	0	5	Defender	Manchester City	28	1994-07-17	18	10
Callum Slattery	0	0	Midfielder	Southampton	23	1999-02-08	18	3
Carl Jenkinson	0	0	Defender	Arsenal	30	1992-02-08	18	3
Cesc Fabregas	0	0	Midfielder	Chelsea	35	1987-05-04	18	6
Conor Coady	0	0	Midfielder	Wolverhampton Wanderers	29	1993-02-25	18	38
David de Gea	0	0	Goalkeeper	Manchester United	31	1990-11-07	18	38
Gaëtan Bong Songo	0	0	Defender	Brighton & Hove Albion	34	1988-04-25	18	22
Georges-Kevin N’Koudou Mbida	0	1	Forward	Tottenham Hotspur	27	1995-02-13	18	1
Grady Diangana	0	1	Midfielder	West Ham United	24	1998-04-19	18	17
Jack Simpson	0	0	Defender	AFC Bournemouth	25	1996-12-18	18	6
Jazz Richards	0	0	Defender	Cardiff City	31	1991-04-12	18	4
Martin Dúbravka	0	0	Goalkeeper	Newcastle United	33	1989-01-15	18	38
Martin Kelly	0	0	Defender	Crystal Palace	32	1990-04-27	18	13
Matty Daly	0	0	Midfielder	Huddersfield Town	21	2001-03-10	18	2
Nampalys Mendy	0	0	Midfielder	Leicester City	30	1992-06-23	18	31
Neeskens Kebano	0	0	Midfielder	Fulham	30	1992-03-10	18	7
Tom Davies	0	0	Midfielder	Everton	24	1998-06-30	18	16
Tom Heaton	0	0	Goalkeeper	Burnley	36	1986-04-15	18	19
André-Frank Zambo Anguissa	0	0	Midfielder	Fulham	26	1995-11-16	19	22
Angel Gomes	0	0	Midfielder	Manchester United	22	2000-08-31	19	2
Asmir Begović	0	0	Goalkeeper	AFC Bournemouth	35	1987-06-20	19	24
Bruno Saltor Grau	0	1	Defender	Brighton & Hove Albion	42	1980-10-01	19	14
Charlie Taylor	0	1	Defender	Burnley	29	1993-09-18	19	38
Fabian Delph	0	1	Midfielder	Manchester City	32	1989-11-21	19	11
Greg Cunningham	0	0	Defender	Cardiff City	31	1991-01-31	19	7
Hugo Lloris	0	0	Goalkeeper	Tottenham Hotspur	35	1986-12-26	19	33
Idrissa Gana Gueye	0	2	Midfielder	Everton	33	1989-09-26	19	33
Jason Puncheon	0	0	Midfielder	Huddersfield Town	36	1986-06-26	19	11
Javier Manquillo Gaitán	0	3	Defender	Newcastle United	28	1994-05-05	19	18
Joe Gomez	0	0	Defender	Liverpool	25	1997-05-23	19	16
Kayne Ramsey	0	0	Midfielder	Southampton	22	2000-10-10	19	1
Konstantinos Mavropanos	0	0	Defender	Arsenal	24	1997-12-11	19	4
Nathaniel Chalobah	0	0	Midfielder	Watford	27	1994-12-12	19	9
Rui Pedro dos Santos Patrício	0	0	Goalkeeper	Wolverhampton Wanderers	34	1988-02-15	19	37
Shinji Okazaki	0	1	Forward	Leicester City	36	1986-04-16	19	21
Vicente Guaita	0	0	Goalkeeper	Crystal Palace	35	1987-01-10	19	20
Wilfredo Daniel Caballero	0	0	Goalkeeper	Chelsea	41	1981-09-28	19	2
Łukasz Fabiański	0	0	Goalkeeper	West Ham United	37	1985-04-18	19	38
Aaron Cresswell	0	1	Defender	West Ham United	32	1989-12-15	20	20
Adam Masina	0	1	Defender	Watford	28	1994-01-02	20	14
Andrew Robertson	0	11	Defender	Liverpool	28	1994-03-11	20	36
Artur Boruc	0	0	Goalkeeper	AFC Bournemouth	42	1980-02-20	20	12
Bernardo	0	1	Defender	Brighton & Hove Albion	27	1995-05-14	20	22
Caglar Söyüncü	0	0	Defender	Leicester City	26	1996-05-23	20	6
Cheikhou Kouyaté	0	2	Midfielder	Crystal Palace	32	1989-12-21	20	31
Gary Madine	0	0	Forward	Cardiff City	32	1990-08-24	20	5
Ibrahima Cissé	0	0	Midfielder	Fulham	28	1994-02-28	20	3
Joshua Sims	0	1	Midfielder	Southampton	25	1997-03-28	20	7
Mateo Kovačić	0	2	Midfielder	Chelsea	28	1994-05-06	20	32
Morgan Schneiderlin	0	1	Midfielder	Everton	32	1989-11-08	20	14
Oleksandr Zinchenko	0	3	Midfielder	Manchester City	25	1996-12-15	20	14
Petr Čech	0	0	Goalkeeper	Arsenal	40	1982-05-20	20	7
Ramadan Sobhi	0	0	Forward	Huddersfield Town	25	1997-01-23	20	4
Stephen Ward	0	0	Defender	Burnley	37	1985-08-20	20	3
Sung-Yeung Ki	0	1	Midfielder	Newcastle United	33	1989-01-24	20	18
Tahith Chong	0	0	Forward	Manchester United	22	1999-12-04	20	2
Toby Alderweireld	0	0	Defender	Tottenham Hotspur	33	1989-03-02	20	34
Adrian Mariappa	0	0	Defender	Watford	36	1986-10-03	21	26
Alex McCarthy	0	0	Goalkeeper	Southampton	32	1989-12-03	21	25
Alex Oxlade-Chamberlain	0	0	Midfielder	Liverpool	29	1993-08-15	21	2
Andreas Christensen	0	0	Defender	Chelsea	26	1996-04-10	21	8
Ben Mee	0	2	Defender	Burnley	33	1989-09-21	21	38
Carlos Sánchez	0	0	Midfielder	West Ham United	36	1986-02-06	21	7
Daniel Williams	0	0	Midfielder	Huddersfield Town	33	1989-03-08	21	5
Danny Simpson	0	0	Defender	Leicester City	35	1987-01-04	21	6
Diego Rico	0	0	Defender	AFC Bournemouth	29	1993-02-23	21	12
Ederson	0	1	Goalkeeper	Manchester City	29	1993-08-17	21	38
Faustino Marcos Alberto Rojo	0	0	Defender	Manchester United	32	1990-03-20	21	5
Jose Izquierdo	0	1	Forward	Brighton & Hove Albion	30	1992-07-07	21	15
Kyle Walker-Peters	0	3	Defender	Tottenham Hotspur	25	1997-04-13	21	6
Lee Peltier	0	0	Defender	Cardiff City	35	1986-12-11	21	20
Leighton Baines	0	0	Defender	Everton	37	1984-12-11	21	6
Mamadou Sakho	0	0	Defender	Crystal Palace	32	1990-02-13	21	27
Mohamed Diamé	0	0	Midfielder	Newcastle United	35	1987-06-14	21	29
Mohamed Elneny	0	0	Midfielder	Arsenal	30	1992-07-11	21	8
Sergio Rico	0	0	Goalkeeper	Fulham	29	1993-09-01	21	29
Aaron Wan-Bissaka	0	3	Midfielder	Crystal Palace	24	1997-11-26	22	35
Abdelhamid Sabiri	0	0	Midfielder	Huddersfield Town	25	1996-11-28	22	2
Davide Zappacosta	0	0	Defender	Chelsea	30	1992-06-11	22	4
Fousseni Diabaté	0	0	Midfielder	Leicester City	27	1995-10-18	22	1
James McCarthy	0	0	Midfielder	Everton	31	1990-11-12	22	1
Joe Ralls	0	0	Midfielder	Cardiff City	29	1993-10-13	22	28
Marouane Fellaini	0	1	Midfielder	Manchester United	34	1987-11-22	22	14
Matthew Lowton	0	0	Defender	Burnley	33	1989-06-09	22	21
Michel Vorm	0	0	Goalkeeper	Tottenham Hotspur	39	1983-10-20	22	2
Nathaniel Clyne	0	1	Defender	AFC Bournemouth	31	1991-04-05	22	18
Paul Dummett	0	0	Defender	Newcastle United	31	1991-09-26	22	26
Pedro Obiang	0	1	Midfielder	West Ham United	30	1992-03-27	22	24
Sead Kolašinac	0	5	Defender	Arsenal	29	1993-06-20	22	24
Sebastian Prödl	0	0	Defender	Watford	35	1987-06-21	22	1
Steven Davis	0	1	Midfielder	Southampton	37	1985-01-01	22	3
Timothy Fosu-Mensah	0	0	Defender	Fulham	24	1998-01-02	22	12
Antonio Valencia	0	0	Defender	Manchester United	37	1985-08-04	23	6
Bakary Sako	0	0	Midfielder	Crystal Palace	34	1988-04-26	23	4
Bernd Leno	0	0	Goalkeeper	Arsenal	30	1992-03-04	23	32
Daryl Janmaat	0	2	Defender	Watford	33	1989-07-22	23	18
Hamza Choudhury	0	0	Midfielder	Leicester City	25	1997-10-01	23	9
Jamal Lascelles	0	1	Defender	Newcastle United	28	1993-11-11	23	32
Joe Bennett	0	1	Defender	Cardiff City	32	1990-03-28	23	30
Luke Amos	0	0	Midfielder	Tottenham Hotspur	25	1997-02-23	23	1
Maxime Le Marchand	0	1	Defender	Fulham	33	1989-10-11	23	26
Maya Yoshida	0	1	Defender	Southampton	34	1988-08-24	23	17
Pablo Zabaleta	0	1	Defender	West Ham United	37	1985-01-16	23	26
Peter Crouch	0	0	Forward	Burnley	41	1981-01-30	23	6
Rajiv van La Parra	0	0	Midfielder	Huddersfield Town	31	1991-06-04	23	5
Tyrone Mings	0	0	Defender	AFC Bournemouth	29	1993-03-13	23	5
Victor Moses	0	0	Midfielder	Chelsea	31	1990-12-12	23	2
Bruno Écuélé Manga	0	1	Defender	Cardiff City	34	1988-07-16	24	38
Christian Kabasele	0	0	Defender	Watford	31	1991-02-24	24	21
Daniel Amartey	0	0	Midfielder	Leicester City	27	1994-12-21	24	9
Jack Wilshere	0	1	Midfielder	West Ham United	30	1992-01-01	24	8
Jan Bednarek	0	1	Defender	Southampton	26	1996-04-12	24	25
Kepa Arrizabalaga	0	0	Goalkeeper	Chelsea	28	1994-10-03	24	36
Lewis Cook	0	0	Midfielder	AFC Bournemouth	25	1997-02-03	24	13
Miguel Ángel Almirón Rejala	0	0	Midfielder	Newcastle United	28	1994-02-10	24	10
Moussa Dembele	0	0	Midfielder	Tottenham Hotspur	35	1987-07-16	24	10
Phil Jones	0	1	Defender	Manchester United	30	1992-02-21	24	18
Rob Holding	0	0	Defender	Arsenal	27	1995-09-20	24	10
Stefan Marius Johansen	0	0	Midfielder	Fulham	31	1991-01-08	24	12
Tom Smith	0	0	Defender	Huddersfield Town	30	1992-04-14	24	15
Angus Gunn	0	0	Goalkeeper	Southampton	26	1996-01-22	25	12
Arthur Masuaku	0	1	Defender	West Ham United	28	1993-11-07	25	23
Jermain Defoe	0	0	Forward	AFC Bournemouth	40	1982-10-07	25	4
Jonas Lössl	0	1	Goalkeeper	Huddersfield Town	33	1989-02-01	25	31
Kasper Schmeichel	0	0	Goalkeeper	Leicester City	35	1986-11-05	25	38
Kevin McDonald	0	0	Midfielder	Fulham	33	1988-11-04	25	15
Leandro Bacuna	0	0	Midfielder	Cardiff City	31	1991-08-21	25	11
Matteo Darmian	0	0	Defender	Manchester United	32	1989-12-02	25	6
Miguel Ángel Britos Cabrera	0	0	Defender	Watford	37	1985-07-17	25	3
Moussa Sissoko	0	3	Midfielder	Tottenham Hotspur	33	1989-08-16	25	29
Stephan Lichtsteiner	0	0	Defender	Arsenal	38	1984-01-16	25	14
Adama Diakhaby	0	0	Forward	Huddersfield Town	26	1996-07-05	26	12
Ben Davies	0	0	Defender	Tottenham Hotspur	29	1993-04-24	26	27
Benjamin Johnson	0	0	Forward	West Ham United	22	2000-01-24	26	1
Eric Bertrand Bailly	0	0	Defender	Manchester United	28	1994-04-12	26	12
Joe Bryan	0	1	Defender	Fulham	29	1993-09-17	26	28
Mattéo Guendouzi Olié	0	0	Midfielder	Arsenal	23	1999-04-14	26	33
Mohamed Elyounoussi	0	0	Midfielder	Southampton	28	1994-08-04	26	16
Simon Francis	0	2	Defender	AFC Bournemouth	37	1985-02-16	26	17
Andrew Surman	0	0	Midfielder	AFC Bournemouth	36	1986-08-20	27	18
Cyrus Christie	0	1	Defender	Fulham	30	1992-09-30	27	28
Hector Bellerin	0	5	Defender	Arsenal	27	1995-03-19	27	19
Laurent Depoitre	0	1	Forward	Huddersfield Town	33	1988-12-07	27	23
Mason Greenwood	0	0	Midfielder	Manchester United	21	2001-10-01	27	3
Serge Aurier	0	2	Defender	Tottenham Hotspur	29	1992-12-24	27	8
Wesley Hoedt	0	0	Defender	Southampton	28	1994-03-06	27	13
Denis Suárez	0	0	Midfielder	Arsenal	28	1994-01-06	28	4
Jannik Vestergaard	0	0	Defender	Southampton	30	1992-08-03	28	23
Jonathan Hogg	0	1	Midfielder	Huddersfield Town	33	1988-12-06	28	29
Mark Travers	0	0	Goalkeeper	AFC Bournemouth	23	1999-05-18	28	2
Vincent Janssen	0	0	Forward	Tottenham Hotspur	28	1994-06-15	28	3
Florent Hadergjonaj	0	0	Defender	Huddersfield Town	28	1994-07-31	29	24
Fraser Forster	0	0	Goalkeeper	Southampton	34	1988-03-17	29	1
Chris Löwe	0	2	Defender	Huddersfield Town	33	1989-04-16	30	29
Aaron Rowe	0	0	Forward	Huddersfield Town	22	2000-09-07	31	2

Best Goalie

A Goalie much like the defender is the last line of defence against the ball. The clean sheets in the end all rely on them.

Goalie <- filter(df, position == "Goalkeeper") %>% 
  select(c('full_name','clean_sheets_overall','position','current_club','age','birthday_gmt', 'appearances_overall' ))

GoalieClean <- Goalie[order(-Goalie$clean_sheets_overall),]

kable(GoalieClean, format = "html" , caption = "Top league Goalies",align = "cccccccccccccccc") %>% kable_styling()

Top league Goalies
full_name	clean_sheets_overall	position	current_club	age	birthday_gmt	appearances_overall
Alisson Becker	21	Goalkeeper	Liverpool	30	1992-10-02	38
Ederson	20	Goalkeeper	Manchester City	29	1993-08-17	38
Jordan Pickford	14	Goalkeeper	Everton	28	1994-03-07	38
Kepa Arrizabalaga	14	Goalkeeper	Chelsea	28	1994-10-03	36
Hugo Lloris	12	Goalkeeper	Tottenham Hotspur	35	1986-12-26	33
Martin Dúbravka	11	Goalkeeper	Newcastle United	33	1989-01-15	38
Kasper Schmeichel	10	Goalkeeper	Leicester City	35	1986-11-05	38
Neil Leonard Dula Etheridge	10	Goalkeeper	Cardiff City	32	1990-02-07	38
Rui Pedro dos Santos Patrício	8	Goalkeeper	Wolverhampton Wanderers	34	1988-02-15	37
Ben Foster	7	Goalkeeper	Watford	39	1983-04-03	38
Bernd Leno	7	Goalkeeper	Arsenal	30	1992-03-04	32
David de Gea	7	Goalkeeper	Manchester United	31	1990-11-07	38
Vicente Guaita	7	Goalkeeper	Crystal Palace	35	1987-01-10	20
Łukasz Fabiański	7	Goalkeeper	West Ham United	37	1985-04-18	38
Mathew Ryan	6	Goalkeeper	Brighton & Hove Albion	30	1992-04-08	34
Asmir Begović	5	Goalkeeper	AFC Bournemouth	35	1987-06-20	24
Jonas Lössl	5	Goalkeeper	Huddersfield Town	33	1989-02-01	31
Sergio Rico	5	Goalkeeper	Fulham	29	1993-09-01	29
Wayne Hennessey	5	Goalkeeper	Crystal Palace	35	1987-01-24	18
Alex McCarthy	4	Goalkeeper	Southampton	32	1989-12-03	25
Artur Boruc	4	Goalkeeper	AFC Bournemouth	42	1980-02-20	12
Joe Hart	4	Goalkeeper	Burnley	35	1987-04-19	19
Tom Heaton	4	Goalkeeper	Burnley	36	1986-04-15	19
Angus Gunn	3	Goalkeeper	Southampton	26	1996-01-22	12
Petr Čech	2	Goalkeeper	Arsenal	40	1982-05-20	7
Wilfredo Daniel Caballero	2	Goalkeeper	Chelsea	41	1981-09-28	2
Ben Hamer	1	Goalkeeper	Huddersfield Town	34	1987-11-20	7
David Button	1	Goalkeeper	Brighton & Hove Albion	33	1989-02-27	4
John Ruddy	1	Goalkeeper	Wolverhampton Wanderers	36	1986-10-24	1
Mark Travers	1	Goalkeeper	AFC Bournemouth	23	1999-05-18	2
Paulo Dino Gazzaniga	1	Goalkeeper	Tottenham Hotspur	30	1992-01-02	3
Will Norris	1	Goalkeeper	Wolverhampton Wanderers	29	1993-08-12	1
Adrián San Miguel del Castillo	0	Goalkeeper	West Ham United	35	1987-01-03	0
Alex Smithies	0	Goalkeeper	Cardiff City	32	1990-03-05	0
Alfie Whiteman	0	Goalkeeper	Tottenham Hotspur	24	1998-10-02	0
Arijanet Muric	0	Goalkeeper	Manchester City	23	1998-11-07	0
Brian Murphy	0	Goalkeeper	Cardiff City	39	1983-05-07	0
Claudio Andrés Bravo Muñoz	0	Goalkeeper	Manchester City	39	1983-04-13	0
Damián Emiliano Martínez	0	Goalkeeper	Arsenal	30	1992-09-02	0
Danny Ward	0	Goalkeeper	Leicester City	29	1993-06-22	0
Fabricio Martín Agosto Ramírez	0	Goalkeeper	Fulham	34	1987-12-31	2
Fraser Forster	0	Goalkeeper	Southampton	34	1988-03-17	1
Freddie Woodman	0	Goalkeeper	Newcastle United	25	1997-03-04	0
Heurelho da Silva Gomes	0	Goalkeeper	Watford	41	1981-02-15	0
Jason Steele	0	Goalkeeper	Brighton & Hove Albion	32	1990-08-18	0
Joe Daniel Tupper	0	Goalkeeper	Crystal Palace	24	1997-11-15	0
Joel Coleman	0	Goalkeeper	Huddersfield Town	27	1995-09-26	1
Julián Speroni	0	Goalkeeper	Crystal Palace	43	1979-05-18	1
Karl Darlow	0	Goalkeeper	Newcastle United	32	1990-10-08	0
Lee Grant	0	Goalkeeper	Manchester United	39	1983-01-27	0
Loris Karius	0	Goalkeeper	Liverpool	29	1993-06-22	0
Maarten Stekelenburg	0	Goalkeeper	Everton	40	1982-09-22	0
Marcus Bettinelli	0	Goalkeeper	Fulham	30	1992-05-24	7
Michel Vorm	0	Goalkeeper	Tottenham Hotspur	39	1983-10-20	2
Ryan Schofield	0	Goalkeeper	Huddersfield Town	22	1999-12-11	0
Sergio Germán Romero	0	Goalkeeper	Manchester United	35	1987-02-22	0
Simon Mignolet	0	Goalkeeper	Liverpool	34	1988-03-06	0

Winning Team

League Rankings

This graph shows the winning team of the league and later on shows the goals they scored giving more context as to why they were ranked this way.

dfTeams %>% 
  ggplot(aes(x= reorder(common_name,+league_position) ,y= league_position )) +
  geom_col() + theme(axis.text.x = element_text(angle = 90)) + labs(x = "Club Name",
                                                                    y = "League Position")

League Ranking Stats

dfWin <- filter(dfTeams) %>% select(c('common_name', 'league_position','performance_rank','goals_scored','goals_conceded',
                                     'goal_difference','matches_played', 'wins' , 'draws', 
                                     'losses', 'points_per_game'  )) 

winClean <- dfWin[order(dfWin$league_position),]

kable(winClean, format = "html" , caption = "Team Performance",align = "ccccccccccc") %>% kable_styling()

Team Performance
common_name	league_position	performance_rank	goals_scored	goals_conceded	goal_difference	matches_played	wins	draws	losses	points_per_game
Manchester City	1	1	95	23	72	38	32	2	4	2.58
Liverpool	2	2	89	22	67	38	30	7	1	2.55
Chelsea	3	3	63	39	24	38	21	9	8	1.89
Tottenham Hotspur	4	4	67	39	28	38	23	2	13	1.87
Arsenal	5	5	73	51	22	38	21	7	10	1.84
Manchester United	6	6	65	54	11	38	19	9	10	1.74
Wolverhampton Wanderers	7	7	47	46	1	38	16	9	13	1.50
Everton	8	8	54	46	8	38	15	9	14	1.42
Leicester City	9	9	51	48	3	38	15	7	16	1.37
West Ham United	10	10	52	55	-3	38	15	7	16	1.37
Watford	11	11	52	59	-7	38	14	8	16	1.32
Crystal Palace	12	12	51	53	-2	38	14	7	17	1.29
Newcastle United	13	13	42	48	-6	38	12	9	17	1.18
AFC Bournemouth	14	14	56	70	-14	38	13	6	19	1.18
Burnley	15	15	45	68	-23	38	11	7	20	1.05
Southampton	16	16	45	65	-20	38	9	12	17	1.03
Brighton & Hove Albion	17	17	35	60	-25	38	9	9	20	0.95
Cardiff City	18	18	34	69	-35	38	10	4	24	0.89
Fulham	19	19	34	81	-47	38	7	5	26	0.68
Huddersfield Town	20	20	22	76	-54	38	3	7	28	0.42

Goal Difference by League Position

dfTeams %>% 
  ggplot(aes(x= league_position ,y= goal_difference, fill = common_name)) +
  geom_col()

Goals Overall By League Position

dfTeams %>% 
  ggplot(aes(x= league_position ,y= goals_scored, fill = common_name)) +
  geom_col()

Who’s Gonna Win?

This section is the most special to me and I think a very interesting part of statistics and football. This is a machine learning program that in theory should be able to predict who should win a game. This is not necessarily 100 percent accurate prediction but the main thing is to deter bookies from scamming odds.

H_df<-dfMatches%>%select(-date_gmt, -away_team_name)%>%
      group_by(status, home_team_name)%>%arrange(game_week)%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(lag))%>%
      na.omit()%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(cummean))%>%
      select(-away_ppg)%>%ungroup()

## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.

## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.

## Warning: There were 40 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `home_team_goal_timings = cummean(home_team_goal_timings)`.
## ℹ In group 1: `status = "complete"`, `home_team_name = "AFC Bournemouth"`.
## Caused by warning in `cummean()`:
## ! NAs introduced by coercion
## ℹ Run ]8;;ide:run:dplyr::last_dplyr_warnings()dplyr::last_dplyr_warnings()]8;; to see the 39 remaining warnings.

colnames(H_df)<-paste("H", colnames(H_df), sep = "_")

A_df<-dfMatches%>%select(-date_gmt, -home_team_name)%>%
      group_by(status, away_team_name)%>%arrange(game_week)%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(lag))%>%
      na.omit()%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(cummean))%>%
      select(-home_ppg)%>%ungroup()

## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.

## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.

## Warning: There were 40 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `home_team_goal_timings = cummean(home_team_goal_timings)`.
## ℹ In group 1: `status = "complete"`, `away_team_name = "AFC Bournemouth"`.
## Caused by warning in `cummean()`:
## ! NAs introduced by coercion
## ℹ Run ]8;;ide:run:dplyr::last_dplyr_warnings()dplyr::last_dplyr_warnings()]8;; to see the 39 remaining warnings.

colnames(A_df)<-paste("A", colnames(A_df), sep = "_")

results_df <- dfMatches %>% select(game_week, status, home_team_name, away_team_name, home_team_goal_count, away_team_goal_count)

final_df <- results_df %>% inner_join(H_df, by=c("home_team_name"="H_home_team_name")) %>% inner_join(A_df, by=c("away_team_name"="A_away_team_name"))

## Warning in inner_join(., H_df, by = c(home_team_name = "H_home_team_name")): Each row in `x` is expected to match at most 1 row in `y`.
## ℹ Row 1 of `x` matches multiple rows.
## ℹ If multiple matches are expected, set `multiple = "all"` to silence this
##   warning.

## Warning in inner_join(., A_df, by = c(away_team_name = "A_away_team_name")): Each row in `x` is expected to match at most 1 row in `y`.
## ℹ Row 1 of `x` matches multiple rows.
## ℹ If multiple matches are expected, set `multiple = "all"` to silence this
##   warning.

h2o.init()

##  Connection successful!
## 
## R is connected to the H2O cluster: 
##     H2O cluster uptime:         14 hours 53 minutes 
##     H2O cluster timezone:       America/Denver 
##     H2O data parsing timezone:  UTC 
##     H2O cluster version:        3.40.0.1 
##     H2O cluster version age:    2 months and 23 days 
##     H2O cluster name:           H2O_started_from_R_ethanwilsher_haa191 
##     H2O cluster total nodes:    1 
##     H2O cluster total memory:   2.69 GB 
##     H2O cluster total cores:    8 
##     H2O cluster allowed cores:  8 
##     H2O cluster healthy:        TRUE 
##     H2O Connection ip:          localhost 
##     H2O Connection port:        54321 
##     H2O Connection proxy:       NA 
##     H2O Internal Security:      FALSE 
##     R Version:                  R version 4.2.3 (2023-03-15)

Train <- final_df%>%filter(game_week <= 38, game_week >= 3)

Test <- final_df%>%filter(game_week >= 20)

Train_h2o <- as.h2o(Train)

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%

Test_h2o <- as.h2o(Test)

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%

aml <- h2o.automl(y = 5,  x=6:62, training_frame = Train_h2o,   leaderboard_frame  = Test_h2o, max_runtime_secs = 60)

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |=                                                                     |   2%
## 09:39:06.375: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |====                                                                  |   5%
  |                                                                            
  |======                                                                |   8%
## 09:39:10.784: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 09:39:10.951: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |========                                                              |  12%
## 09:39:12.930: _train param, Dropping unused columns: [H_referee, H_status]
## 09:39:13.251: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===========                                                           |  15%
  |                                                                            
  |=============                                                         |  19%
## 09:39:16.601: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 09:39:18.504: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===============                                                       |  22%
## 09:39:19.914: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |==================                                                    |  25%
## 09:39:21.223: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |====================                                                  |  29%
## 09:39:23.10: _train param, Dropping unused columns: [H_referee, H_status]
## 09:39:23.320: _train param, Dropping unused columns: [H_referee, H_status]
## 09:39:23.798: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |=======================                                               |  32%
  |                                                                            
  |=========================                                             |  36%
## 09:39:26.967: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===========================                                           |  39%
## 09:39:29.923: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |==============================                                        |  42%
## 09:39:31.208: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 09:39:31.993: _train param, Dropping unused columns: [H_referee, H_status]
## 09:39:32.428: _train param, Dropping unused columns: [H_referee, H_status]
  |                                                                            
  |================================                                      |  46%
  |                                                                            
  |==================================                                    |  49%
  |                                                                            
  |=====================================                                 |  53%
  |                                                                            
  |=======================================                               |  56%
  |                                                                            
  |==========================================                            |  59%
  |                                                                            
  |============================================                          |  63%
  |                                                                            
  |==============================================                        |  66%
  |                                                                            
  |=================================================                     |  70%
  |                                                                            
  |===================================================                   |  73%
  |                                                                            
  |=====================================================                 |  76%
  |                                                                            
  |========================================================              |  80%
  |                                                                            
  |==========================================================            |  83%
  |                                                                            
  |=============================================================         |  87%
  |                                                                            
  |===============================================================       |  90%
  |                                                                            
  |=================================================================     |  93%
  |                                                                            
  |====================================================================  |  97%
## 09:40:04.10: _train param, Dropping unused columns: [H_referee, H_status]
## 09:40:04.360: _train param, Dropping unused columns: [H_referee, H_status]
  |                                                                            
  |======================================================================| 100%

lb <- aml@leaderboard

pred <- h2o.predict(aml@leader, Test_h2o)

## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%

h2o.performance(model = aml@leader, newdata = Train_h2o)

## H2ORegressionMetrics: gbm
## 
## MSE:  1.065758
## RMSE:  1.032355
## MAE:  0.7749278
## RMSLE:  0.429384
## Mean Residual Deviance :  1.065758

Am I A Good Player?

In this section there are 4 graphs that show a correlation between how many goals someone should score and how good they should be.

mod1 <- glm(data = df,
            formula = goals_overall ~ age + current_club + assists_overall + red_cards_overall + minutes_played_overall + clean_sheets_overall)

mod2 <- glm(data = df,
            formula = goals_overall ~ age * current_club * assists_overall * red_cards_overall * minutes_played_overall * clean_sheets_overall)

compare_performance(mod1,mod2) %>% plot()

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=age, y= pred)) +
          geom_smooth() + labs(title = "Age")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=assists_overall, y = pred)) +
          geom_smooth() + labs(title = "Assists")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x = minutes_played_overall, y = pred)) +
          geom_smooth() + labs(title = "Minutes Played")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=clean_sheets_overall, y = pred)) +
          geom_smooth() + labs(title = "Clean Sheets")

Takeaway

My take away from studying the data is that it can be really easy to talk about who is at the top of the league and who is scoring the most just by reading a table but there is a lot more that the data does not flat out tell you. So my advice is if you want to talk to people about football just watch a bit and ask questions. There also is a lot of things that they do not collect for data but speak of more in passing like passes and time ball was controlled.